| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Address
I have a range ( J8:T8) which contain various values. I am using MAX(J8:T8)
to return the largest number in that range. I also need to know what the cell address is of that value. Is there a formula I can write that will return the address of the cell in the range with the highest value? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| Passing Cell Address to Offset | Excel Worksheet Functions | |||
Threaded Mode
