Choose highest value in a row

sohum.shah · Oct 23, 2006

How do I tell excel to choose the highest value in a range of cells?

A B C D E Highest
1 3 2 7 5 7

help please.

Dave Peterson · Oct 23, 2006

=max(a1:e1)
will return the highest value.

How do I tell excel to choose the highest value in a range of cells?

A B C D E Highest
1 3 2 7 5 7

help please.

Gord Dibben · Oct 23, 2006

=MAX(A1:E1) returns 7 in your example.

Gord Dibben MS Excel MVP

sohum.shah · Oct 23, 2006

Dave said:
=max(a1:e1)
will return the highest value.

thank you