Lookup top 5 values (MAX function?)
 

I'm hoping to populate a table showing the top 5 values in a list of
20,000+ currency values.

Without having to sort, is there any way of looking up the MAX -1,
MAX-2, etc.??

Any help will be greatly appreciated.

Thanks,
Donnie

Lookup top 5 values (MAX function?)
 

=large(A1:A1000,ROW(A1))

and copy down as many as you want

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
I'm hoping to populate a table showing the top 5 values in a list of
20,000+ currency values.

Without having to sort, is there any way of looking up the MAX -1,
MAX-2, etc.??

Any help will be greatly appreciated.

Thanks,
Donnie

Lookup top 5 values (MAX function?)
 

Or maybe

=large($A$1:$A$1000,row(A1))

--

Regards,

Peo Sjoblom

"Bob Phillips" wrote in message
...
=large(A1:A1000,ROW(A1))

and copy down as many as you want

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
I'm hoping to populate a table showing the top 5 values in a list of
20,000+ currency values.

Without having to sort, is there any way of looking up the MAX -1,
MAX-2, etc.??

Any help will be greatly appreciated.

Thanks,
Donnie