Choosing largest number in range

[Guest]

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

Thanks

 

[Ken Wright]

=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
----------------------------------------------------------------------------

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

accomplished by nesting functions ?

 

[Frank Kabel]

Hi Mike
try
=MAX(A1:A100)

 

[Ron Rosenfeld]

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

Thanks

=MAX(rng)


--ron

 

[Norman Harker]

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.

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

accomplished by nesting functions ?