Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

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
0
Ladkisson
Asked:
Ladkisson
1 Solution
 
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
 
SteveCommented:
Something like the following should work:

=CELL("address",INDEX(A2:A15,MATCH(MAX(A2:A15),A2:A15,0)))
Example.xlsx
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now