MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Selecting Highest value in a number of cells?


Posted by Tom on December 04, 2001 11:27 PM

Sorry if this has been covered before, but with over 32,000 posts to go through this seem the easiest way.

I have a spread sheet with assorted numbres in different cells... say C2 11, G14 5, and F30 22... How do I get cell A1 to display the highest value from all those cells with out a bunch of IF statements. (I have more than 7 cells I am trying to test)

If you could post here or email me I would be forever in your debt.

Thanks in advance.


Posted by Ian Bartlett on December 05, 2001 12:17 AM

Use the MAX() function. You can get it to evaluate a discontinuous range by clicking the first cell, add a comma, click the next cell (or range of cells), etc. eg.
=MAX(D7,D9,D14,G14:H25)

HTH,

Ian