Choose highest value in a row

  • Thread starter Thread starter sohum.shah
  • Start date Start date
S

sohum.shah

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.
 
=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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting & formula 4
How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 1
Finding the biggest number out of 8 variables 11
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Conditional format question 4
VBA 0
Ranking, I think 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Back
Top