Return a High Number

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Is there a formula if in diffrent cells I have a number and I want it to
return the highest number is that area. If anyone could please help.

Thanks
 
The MAX function will return the largest value of a range. E.g.,

=MAX(A1:A10)


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
If your numbers are in A1:C10 then =MAX(A1:C10) returns the highest number
in the range.

Tyro
 
Try:
=count(a1:c10)
(change the range to match)

Maybe those things that look like numbers aren't really numbers.
 
Back
Top