Many people find the process to faint address in excel rather difficult, especially if they don't frequently work with documents. However, these days, you no longer have to suffer through long instructions or wait hours for the editing app to install. DocHub enables you to change documents on their web browser without installing new programs. What's more, our robust service offers a full set of tools for comprehensive document management, unlike numerous other online tools. That’s right. You no longer have to donwload and re-upload your templates so frequently - you can do it all in one go!
Whatever type of document you need to modify, the process is straightforward. Benefit from our professional online solution with DocHub!
welcome to excel magic tricks 1794 and in this video we want to see how to look up the cell address for the max value well the first thing is letamp;#39;s add some conditional formatting so i highlight all the numbers go up to the home tab conditional formatting top bottom rules top ten weamp;#39;ll change it to one and use custom format something like fill red font white click ok click ok so now we can visually see thatamp;#39;s what weamp;#39;re after but we want the address b 32 well we first need to find the max value so weamp;#39;ll use the max function if we enter that we get the max value now i want to look up the position of that max value so weamp;#39;ll use the x match lookup the lookup value is the max value comma lookup array that same range the default is exact match close parentheses and that will give us 29. well we actually need 32 f2 weamp;#39;ll add the row of the column header or field name that will give us 32 f2 with that 32 we can construct an address using
