Menu

How do i get the top 5 numbers in a range of cells?

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Don Guillett

Posts: n/a

Default

Have a look in HELP index for LARGE

--
Don Guillett
SalesAid Software

"Master" wrote in message
...
Hi everyone!

How do i get the top 5 numbers in a range of cells?

example:

A B C
100
25
34
65
87
12
10
99

I was already able to get the highest number using the max function.
=max(a1:a8)
In another set of cells i want the formula to return the value of the 2nd
to
the highest and so on and so forth.

Thanks for the help.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What formula is used for subtracting a range of different cells f.	tim	Excel Worksheet Functions	3	April 21st 23 10:07 PM
Converting negative numbers in a range of cells to zero	Dede	Excel Discussion (Misc queries)	3	January 14th 05 06:23 PM
How do I create formula to count numbers in a range of cells?	EmilyJ	Excel Worksheet Functions	1	December 8th 04 05:24 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
index to a range of cells	Frank Kabel	Excel Worksheet Functions	0	October 27th 04 05:39 PM

All times are GMT +1. The time now is 05:41 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement