Top 5?

[Guest]

I have sorted a list of 100+ entries, 4 columns worth of data per entry.
I can sort the data to give me an average #, a high and a low #

What I would like for Excel to do is to list the top five entries & their
data for the top five scores and the bottom five scores.

For example:

Bottom 5 based off of the 2nd column

John Doe 125 250
Jane Doe 129 250
Jack Doe 133 275
Jim Doe 135 255
Julie Doe 140 230

Top 5 based off of the 2nd column

Julie Doe 140 230
Jim Doe 135 255
Jack Doe 133 275
Jane Doe 129 250
John Doe 125 250

 

[AlfD]

Hi!

Use the LARGE() and SMALL() worksheet functions. Help will give you th
syntax.

Al

 

[Guest]

Have you tried filtering?

 

[Aladin Akyurek]

http://tinyurl.com/4xr76