determine which cell a value is returned from

C

curiousg

How to determine which cell a value is returned from. e.g.=MAX(D6:CC280)
returns 525 - How do I find the cell where it occurs?
 
J

JulieD

Hi

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

Cheers
JulieD
 
J

Jason Morin

One way:

=ADDRESS(MAX(IF(MAX(D6:CC280)=D6:CC280,ROW(D6:CC280))),MAX
(IF(MAX(D6:CC280)=D6:CC280,COLUMN(D6:CC280))),4)

Array-entered, meaning press ctrl + shift + enter.

HTH
Jason
Atlanta, GA
 
Top