Need to rank a columns contents based on another column

I have a column of numbers which shows order of finish in a tournament.

Example for the following columns.
Col A Col B Col C Col D Col E Col F
Player Name MP Game W/L Ratio Points W/L Ratio Place TieBreak Ranking
Raquel Welch 20 1.67 1.11 1 0
Bill Wallace 19 1.32 1.04 2 0
Janet Leigh 18 1.29 1.06 3 1
Jay Boateng 18 1.04 0.97 3 3
Toni Tenille 18 1.05 1 3 2
Barry Scott 17 0.96 1 6 0
Clark Gable 16 1 1.02 7 1
Alex Trebek 16 0.91 1.01 7 2
Sean Hernandez 16 1.05 1.01 7 2
Shawn Sapp 14 0.84 0.96 10 1
Jean-Marie Kanai 14 0.8 0.94 10 2
Mark Masters 12 0.5 0.88 12 0


I would like to have column F do a ranking of column D by descending order but only for those players who are tied (same value in column E) - I'd like a constant value of zero for players not tied in column E. So cell F2 and F3 would have value 0. Since E4 thru E6 are tied with value of 3 then column F formula would rank column D in descending order as follows - F4 thru F6 would have value of 1, 3, 2. If column D has same value on a tiebreaker set then they should have the same value in column E - example in rows 8 thru 10.

Is there a way to accomplish this via a formula or by a vba macro? I need to rank rows 2 thru 13 only.

Please let me know if this is do-able?

PS - the example above became skewed after I posted it - please refer to the attachment instead.

Thanks for any help you can give.

Try this Macro

Please Login or Register  to view this content.

This can be reduced to:

Please Login or Register  to view this content.

How about using this formula, instead of fiddling about with a helper column?
E2=RANK($B2,$B$2:$B$13)+COUNTIF($B$2:B2,B2)-1
copied down

Not really sure what you want then. Below shows how I used my suggestion to rang...

	A	B	C	D	E	F	G
1	Player Name	MP	Game W/L Ratio	Points W/L Ratio	Place	TieBreak Ranking	Mine
2	Raquel Welch	20	1.67	1.11	1	0	1
3	Bill Wallace	19	1.32	1.04	2	0	2
4	Janet Leigh	18	1.29	1.06	3	1	3
5	Jay Boateng	18	1.04	0.97	3	3	4
6	Toni Tenille	18	1.05	1	3	2	5
7	Barry Scott	17	0.96	1	6	0	6
8	Clark Gable	16	1	1.02	7	1	7
9	Alex Trebek	16	0.91	1.01	7	2	8
10	Sean Hernandez	16	1.05	1.01	7	2	9
11	Shawn Sapp	14	0.84	0.96	10	1	10
12	Jean-Marie Kanani	14	0.8	0.94	10	2	11
13	Mark Masters	12	0.5	0.88	12	0	12

If this was not what you wanted, then what did you want?

All you need do is to insert a Min ( Minimum Instruction ) Minimum of ( Calculated and 2)

Please Login or Register  to view this content.

Sorry, I'll try to explain the issue more clearly.

In the attached spreadsheet column E signifies the order of finish for players in a tournament. cell E2 has a value of "1",
E3 has value "2", then E4, E5 and E6 all have value of "3". This means those 3 players tied for 3rd place.

So I want all the tied players for one position to be ranked descending based on value of column D. If one or more players
involved in a tie have the same value in column D, they should have the same ranking.

Therefore the 3 players tied for 3rd place should be ranked as follows: E4 Ranked "1" E5 Ranked "2" E6 Ranked "3" based
on column D'S descending values.

In the attachment there is a tie for seventh place among 3 players. Cell E8 is the highest value of the three (col D)
and gets a ranking of "1", E9 and E10 have the same value in col. D and both should have a ranking of "2".

If for example we have a 5 player tie for first place and the all had same value in column D then all 5 would have a
ranking of "1"

Macro2 results are in col F in the attachment - I've add a column H to show the values I'm wanting to get. I've
hi-lited the cells in column H which are different from the macro's results in col. F.

Thanks so much for your help.