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.