Need help ASAP

[adurham22926192]

I’m making a scoring system for Irish Dancing. I need help. I have all of the competitors numbers listed in Column A. Then I have the score that they got in Column B. Then i want it to be able to show who is first , second etc what number they are and how many marks they were given? Please help

 

[VBE313]

Screenshot your data for example

 

[AhoyNC]

Maybe something like this.

Book1
	A	B	C	D	E	F
1	Competitor#	Score		Place	Competitor#	Score
2	Comp1	77		1	Comp9	124
3	Comp2	86		2	Comp6	120
4	Comp3	101		3	Comp8	116
5	Comp4	84		4	Comp7	103
6	Comp5	82
7	Comp6	120
8	Comp7	103
9	Comp8	116
10	Comp9	124
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=INDEX($A$2:$A$10,MATCH(LARGE($B$2:$B$10,$D2),$B$2:$B$10,0))
F2:F5	F2	=LARGE($B$2:$B$10,$D2)

 

[adurham22926192]

Thank so much. I also wanted to have in Column G next to their score a score that is converted so first place gets 100 second 49 third 24 fourth 11 5th 6 6th 5 7th 4 8th 3 9th 2 and 10th 1. And if there are two people tieing say in first place with 124 points I want it to add the first place mark and the second place mark (100 and 49) and divide by how many people are tieing so 2 so they would get 74.5 points each