determine which cell a value is returned from

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi

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

Cheers
JulieD
 
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
 
Jason,
That works great! The "array-entered" hint is especially appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the values? 1
How do I write this formula 1
How to determine the closed value? 7
How to determine the value - 18 Dec? 5
Using cell value to build external reference 11
How to put Zero in a cell 6
How to keep formula and be able to input value in cell? 0
How to determine the value? 2

Back
Top