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.


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

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.


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

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

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.


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

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

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

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

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