Getting the top 5
 

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:


--
King
------------------------------------------------------------------------
King's Profile: http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705

Getting the top 5
 

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
--
Gary's Student


"King" wrote:


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:


--
King
------------------------------------------------------------------------
King's Profile: http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705

Getting the top 5
 

http://cjoint.com/?fAhFsz3PcT

-Select 5 cells
=INDEX(nom;Match(Large(Percent-Row(Percent)/10^10;{1;2;3;4;5});Percent-Row(Percent)/10^10;0))

-Validate with Shift+Ctrl+Enter

Cordialy JB

Getting the top 5
 

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

"King" wrote in message
...

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:


--
King
------------------------------------------------------------------------
King's Profile:
http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705

Getting the top 5
 

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

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


--
King
------------------------------------------------------------------------
King's Profile: http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705

Getting the top 5
 

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

nom and percent are named ranges.

Biff

"King" wrote in message
...

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

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


--
King
------------------------------------------------------------------------
King's Profile:
http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705

Getting the top 5
 

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


--
King
------------------------------------------------------------------------
King's Profile: http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705

Getting the top 5
 

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

"King" wrote in message
...

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


--
King
------------------------------------------------------------------------
King's Profile:
http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705