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! |
#2
|
|||
|
|||
This is one way to return the first max value in the range:
=ADDRESS(8,9+MATCH(MAX(J8:T8),J8:T8,0)) In article , Michael Link <Michael wrote: 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! |
#3
|
|||
|
|||
Wow! That does it! I'm quite sure that I wouldn't have gotten to this for a
long time--if ever. Thank you so much! M. Link "JE McGimpsey" wrote: This is one way to return the first max value in the range: =ADDRESS(8,9+MATCH(MAX(J8:T8),J8:T8,0)) In article , Michael Link <Michael wrote: 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! |
#4
|
|||
|
|||
try this one line array formula which must be entered with ctrl+shift+enter
ADDRESS(MAX(IF(A1:C10=MAX(A1:C10),ROW(A1:C10))),MA X(IF(A1:C10=MAX(A1:C10),CO LUMN(A1:C10)))) -- Don Guillett SalesAid Software "Michael Link" <Michael wrote in message ... 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! |
Reply |
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 |