How do I return the highest value in a range of cells

[Guest]

How do I return the highest value in a range of cells

 

[Bob Phillips]

=max(a1:a3)

 

[KL]

try:

=MAX(A1:A100)

Regards,
KL

 

[Domenic]

How do I return the highest value in a range of cells

Try...

=INDEX(A1:A100,MATCH(MAX(A1:A100),A1:A100,0))

or

=INDEX(A:A,MATCH(MAX(A:A),A:A,0))

Hope this helps!

 

[Domenic]

Please ignore...

Try...

=INDEX(A1:A100,MATCH(MAX(A1:A100),A1:A100,0))

or

=INDEX(A:A,MATCH(MAX(A:A),A:A,0))

Hope this helps!

 

[Ron Rosenfeld]

How do I return the highest value in a range of cells

Look at HELP for the MAX worksheet function.


--ron