I NEED HELP PLEASSEEE

[adurham22926192]

Hi I have the competitor numbers in column A (A1: 101, A2:108 etc) and their score in column B (B1: 87.00, B2: 84.00) and i need a formula for C1 to look up the highest score in the column B and return the competitors number, and so on so look up the second largest score and return the competitors number.

Please help thanks so much

 

[adurham22926192]

Hello again,

This is what I have so far

Column A: competition number (101,102,103,104)
Column B: score (87,89,86,89)
Column C: the countif formula
Column D: rank without skipping numbers
Column G: the index formula

i want in Column F for it to say 1st next to the highest score in column G but if there is a tie for 1st it will say 1st for both and then 2nd 3rd etc. I just want it to do ties without skipping. I’ve tried the small formula but if their is duplicates it doesn’t work.

Please help me ASAP

Thanks so much

 

[J.Ty.]

Here you go. I have made two variants of the rank. One assumes that if the first two players tie the next one is 3rd, in the other one (which seems to follow from your description) the next after the first two is actually 2nd. Choose whichever you prefer.

Book2 (version 1).xlsb
	A	B	C	D	E	F
1
2	id	score	help	id	rank v. 1	rank v. 2
3	1	77	4	12	1	1
4	3	54	7	65	1	1
5	5	37	8	8	3	2
6	6	75	5	1	4	3
7	8	89	3	6	5	4
8	12	101	1	4	5	4
9	4	75	6	3	7	5
10	65	101	2	5	8	6
Sheet1

Cell Formulas
Range	Formula
C3:C10	C3	=COUNTIF($B$3:$B$10,">"&B3)+COUNTIF(B$3:B3,"="&B3)
D3:D10	D3	=INDEX($A$3:$A$10,MATCH(ROW()-2,$C$3:$C$10,0))
E3:F3	E3	=1
E4:E10	E4	=IF(INDEX($B$3:$B$10,MATCH(ROW()-2,$C$3:$C$10,0))=INDEX($B$3:$B$10,MATCH(ROW()-3,$C$3:$C$10,0)),E3,ROW()-2)
F4:F10	F4	=IF(INDEX($B$3:$B$10,MATCH(ROW()-2,$C$3:$C$10,0))=INDEX($B$3:$B$10,MATCH(ROW()-3,$C$3:$C$10,0)),F3,F3+1)