ExcelBanter - determine which cell a value is returned from

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - determine which cell a value is returned from (https://www.excelbanter.com/excel-discussion-misc-queries/12288-determine-cell-value-returned.html)

curiousg

determine which cell a value is returned from

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?

JulieD

Hi

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

Cheers
JulieD

"curiousg" wrote in message
...
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?

Jason Morin

One way:

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

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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?
.

Garret

Jason,
That works great! The "array-entered" hint is especially appreciated.

"Jason Morin" wrote:

One way:

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

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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?
.

All times are GMT +1. The time now is 10:03 AM.