Trying to Figure Out how to Tackle Bowling Ties

[RudeBoy]

Currently I have an elaborate set of workbooks coded up for my Bowling League.
The main headache I face Seasonally is TIES. I have different categories that pay-out different amounts of Prize money.. I use Formula Ranking code as such: =RANK(M9, $M$9:$M$13319) When a tie occurs it is usually double or triple or quadruple sometimes.

Lets say as an example we have 10 places to pay and i am creating 10 Labels to pay these spots off.. After the bowling is done we have 4 bowlers tied for 1st place.. The Ranking Formula will kick out all 4 Bowlers with a Ranking of 1. So you have in the Spread-sheet N9=1,N10=1,N11=1 & N12=1. Now what happens is each place has a money value so lets keep it simple 1st place it $1000 2nd place is $900 3rd place is $800 and $700 is for 4th place.. Normally when we have a tie we combine the 4 spots $1000 thru $700 and then divide by 4. So $1700 divided by 4 = $425 each. Normally we have to do all this by hand and identify all these ties after we print the labels etc.. I want to be able to have EXCEL identify these ties upfront no matter how many there are and also figure out how much to divide to each bowler and have my labels kicked out and ready to print as soon as I get done entering all the scores.. I figure I maybe able to use this type of formula that I used in my Fantasy Football Sheets =INDEX('BYES-DIV'!E2:E33,MATCH(E8,'BYES-DIV'!C2:C33,0))
HELPppppppppppppppppppppppppppppppp

 

[T. Valko]

If I wanted to create 1st Place, 2nd Place 3rd Place etc.. Is there an easy way to match the Ranks and turn that into a value of 1st Place, 2nd Place etc? So example if C1 = 1, "1st Place" etc but there are multiple positions, so what is the easiest way to translate the current Ranking to a value of 1st Place etc without messing up the formulas?

Helppppppppp

Thanks.. Let me know..

Do you mean something like this:

Book1
	C	D
2	1	1st Place
3	1	1st Place
4	2	2nd Place
5	3	3rd Place
6	3	3rd Place
7	4	4th Place
8	5	5th Place
9	5	5th Place
10	6	6th Place
Sheet1

This formula entered in D2 and copied down:

=C2&MID("thstndrdth",MIN(9,2*RIGHT(C2)*(MOD(C2-11,100)>2)+1),2)&" Place"

 

[RudeBoy]

Thanks That worked.. AWESOME!!

 

[T. Valko]

Thanks That worked.. AWESOME!!

You're welcome. Thanks for the feedback!