Choosing largest number in range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Don't see a function to choose largest number in range. Can this be accomplished by nesting functions

Thanks
 
=MAX(Rng)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Mike Klein said:
Don't see a function to choose largest number in range. Can this be
Click to expand...
accomplished by nesting functions ?
 
Hi Mike!

Although MAX is clearly the function you want. There is also LARGE
which allows you to get the kth largest number in a data set.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Mike Klein said:
Don't see a function to choose largest number in range. Can this be
Click to expand...
accomplished by nesting functions ?
 
Back
Top