Ranking numbers in a column from 1 to 15 then stating the rank in another column

Hello,

Looking for help with how to rank a column of numbers from 1 to 15, then listing the top 5 or top 4 in another column.

For example column AA has 15 numbers listed in it as

01 17.12
02 19.24
03 21
04 07
05 28
06 15
07 14.27
08 10
09 09
10 54.98
11 26
12 31
13 23.04
14 78
15 91

What I am trying to accomplish is for the spread sheet to rank those numbers from 1 to 15 ...

04 01
09 02
08 03
07 04
06 05
01 06
02 07
03 08
13 09
11 10
05 11
12 12
10 13
14 14
15 15

then I am trying to list the top 5 in one column and the top 4 in another column in cells 15 to 19 for example using the cell numbers.

04
09
08
07
06

Should a tie exist between 2 or more entries I would like to resolve the tie using a ranking of numbers from another column.

I most certainly appreciate any help with this that you can provide.

Thank you again,
Leonard

See attached file

Why not just sort by col B?

	A	B
1	4	7.00
2	9	9.00
3	8	10.00
4	7	14.27
5	6	15.00
6	1	17.12
7	2	19.24
8	3	21.00
9	13	23.04
10	11	26.00
11	5	28.00
12	12	31.00
13	10	54.98
14	14	78.00
15	15	91.00

Like this?

See attachment.

Not quite to the end but certainly making headway.

Hi Leonard,

Sorry it has traken so long to get back to you. For some reason this day turned out to be an extra long one.

I attached what I have so far, taking care of ranking only on criteria 1 unless there is a tie. Change the value in AB12 to 17.12 (or whatever) and the second criteria information goes away leaving only the numbers for top 5 and 4 being taken from the Place 1 column and from Place Total column. Notice the additional column labeled as CountIF > 1. This is how it finds out if there are any duplicates in the Place 1 column.

I'm thinking about the rest.... Not quite sure how to do it but there's got to be a way. I'll post again when I have something or if I can't figure it out...

Question: There wouldn't happen to be some team names in another column for each of these 15 rows, would there? If there is, would the team name being returned in AI2 through AI6 be ok instead of returning the actual cell it came from?

Leonard,

Is this what you are looking for? Returning the absolute cell address for top 5 and 4 in column AI. Basically, you can enter the criteria into AB2 through 16 in whatever order you want and then push the Sort button. Cells AI2 through 6 return the absolute cell address of AB2 through 6 unless there is a tie and AF2 through 6 if there is a tie.

What's happening? What isn't working?