View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Largest number 2

Hi Max
Type this =MAX(C2:C100) in C1, change range to your needs
HTH
John
"MAX" wrote in message
...
I have a range of cells with a number in each cell (below).
Cell C1 2
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell C1.

Thanks