Lookup top 5 values (MAX function?)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

donniemaclean@gmail.com - 14 Dec 2005 10:47 GMT

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

Reply to this Message

Bob Phillips - 14 Dec 2005 11:00 GMT

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

and copy down as many as you want

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> I'm hoping to populate a table showing the top 5 values in a list of
> 20,000+ currency values.
[quoted text clipped - 6 lines]
> Thanks,
> Donnie

Reply to this Message

Peo Sjoblom - 14 Dec 2005 14:09 GMT

Or maybe

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

Signature

Regards,

Peo Sjoblom

> =large(A1:A1000,ROW(A1))
>
[quoted text clipped - 10 lines]
> > Thanks,
> > Donnie

Reply to this Message