Finding the Address of a Cell
(Formulas shown in sections for readability)
Try this regular formula:
=CELL("address",INDEX(J8:J65000,MATCH(MAX(
INDEX((J8:J65000<K6)*J8:J65000,0)),J8:J65000,0)))
or...this ARRAY FORMULA version,committed with CTRL+SHIFT+ENTER:
=CELL("address",INDEX(J8:J65000,MATCH(MAX(
(J8:J65000<K6)*J8:J65000),J8:J65000,0)))
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"tb" wrote in message
...
Is there a way to find the cell address where a specific value is?
If I wanted to know in which row (of column P) I have the greatest
value that is <= 80, how would I do that?
Thanks.
--
Tiziano
|