Return the cell location of a value

[Shawn]

Quick question- how do I return the cell location of a
value? For example, if I wanted to find the maximum value
of a range, it would be =max(range). Once I get that
number, however, how do I have Excel return the location
of that cell?
Thanks-
Shawn

 

[JulieD]

Hi Shawn

one way
=CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0)))

where A:A is your range

Cheers
JulieD

 

[Frank Kabel]

Hi
try:
=CELL("address",INDEX(A1:A100,MATCH(MAX
(A1:A100),A1:A100,0)))

 

[Shawn]

Thank you very much.

-----Original Message-----
Hi
try:
=CELL("address",INDEX(A1:A100,MATCH(MAX
(A1:A100),A1:A100,0)))

.

 

[Shawn]

Thank you very much.

-----Original Message-----
Hi
try:
=CELL("address",INDEX(A1:A100,MATCH(MAX
(A1:A100),A1:A100,0)))

.

 

[Aladin Akyurek]

http://tinyurl.com/6q4qe