Getting the top 5

K

King

Okay I need some help. I have a 3D excel workbook, on one page I have
names and percentages. On another sheet I want to display the names of
the people with the top 5 percentages. However some of their
percentages are the same. I have fooled around with using an IF
function with a Large as the array and the names if true. However I'm
lost after that and I think I'm way over my head, any suggestions or
help would be greatly appreciated. Thank you.:confused: :confused:
 
G

Gary''s Student

As you have discovered, ties in percentage make using LARGE() in conjunction
with MATCH or VLOOKUP difficult.

Probably just as easy to copy over the columns and sort by percentage
descending
 
B

Biff

Hi!

How do you define top 5?

10
10
10
9
8
7
6


Would the top 5 be: 10.....10......10.....9.....8
..................................1.......2........3.....4.....5

Or, would the top 5 be: 10.....10.....10.....9.....8.....7.....6
.......................................1.......1.......1......2.....3.....4.....5

Biff
 
K

King

The best would be like 100%(or closest too), second would be the percen
under that etc.

I tried JBs formula but what goes in the percent area? and nom is th
number...ie....1-5 right
 
B

Biff

Download the sample file JB posted. I opened it and it's safe.

nom and percent are named ranges.

Biff
 
K

King

okay but how do you use this as a named range if its in 3D workbooks? It
just gives me an error that theres an error in the formula when I try
and enter the formula
 
B

Biff

Send me an email and I'll put together a sample file that does what you
want. Or, send me your file which would be even better. I'm at:

xl can help at comcast period net

Remove "can" and change the obvous.

Biff
 
Top