P
pjs83
How do I return the highest value in a range of cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=max(a1:a3)
K
KL
try:
=MAX(A1:A100)
Regards,
KL
=MAX(A1:A100)
Regards,
KL
D
Domenic
pjs83 said: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!
D
Domenic
Please ignore...
Domenic said: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!
R
Ron Rosenfeld
How do I return the highest value in a range of cells
Look at HELP for the MAX worksheet function.
--ron