Biggest values

[Cadmium]

Hi guys, how are you all doing?

Well, here is my question:

In column A, I have a list of numbers, from 1 to 60.
In column B, I wrote down how many times a number in column A appeared during an experiment.
In column C, I calculated the % of times a number in column A appeared, simply by dividing, for each number, the value in B by the sum of all cells in B.

What I want Excel to do is: select the 1st, 2nd, 3rd, 4th, 5th and 6th biggest % (values in C) and give me the corresponding numbers in column A.

Can you guys help me?
Thanks!

[pike]

hi Cadmium

You could use the =Rank( ) function

[DonkeyOte]

You could even use a Pivot Table ... will also avoid issues of duplicity of %.

If you can post a quick sample of your data you will invariably get a number of alternative approaches from which to choose.