Max formula

Hi,

how do I need to adjust the max formula in order for it to point me back to that cell that has the highest value?  Thanks
LadkissonAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
Something like the following should work:

=CELL("address",INDEX(A2:A15,MATCH(MAX(A2:A15),A2:A15,0)))
Example.xlsx
0
 
helpfinderIT ConsultantCommented:
like this it should work:
=MAX(A1:A6)

see also attached sample

from visual aspect it could be a solution also to use Conditional formating so you will have the highest value highlighted
sample.xlsx
0
 
LadkissonAuthor Commented:
no it just gives me the highest value it does not say that this value is in Cell A6
0
 
NBVCCommented:
Try:

=ADDRESS(MATCH(MAX(A:A),A:A,0),1,4)

where you are looking in column A
0
 
helpfinderIT ConsultantCommented:
then use
=ADDRESS(MATCH(MAX(A:A);A:A;0);1;4)
where 1 represents column number - for C change to 3
sample.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.