Index/match with duplicate score results

[Phyreguy]

Have 2 small personal projects on the go

One is a scoreboard for multiple events and the other is a personal work call in sheet. Both are the same idea.
First one is shows results for all teams and their standing 1st, 2nd 3rd and so on
Team1. 40
Team2 30
Team3. 30
However because there are scores that are the same I get...
Team1. 40
Team2. 30
Team2. 30
Instead of showing Team 3 with the 30. Pts

The work one is the same just with 2 workers with the same hrs it only shows the first instance but repeats the name again in the next cell with the same hrs.
Will try to get a sheet up

 

[Snakehips]

@Phyreguy As you are likely aware, the above is a tad vague.
Does the below offer you potential for a solution?

Book3
	A	B	C	D	E	F
1	Team	Points	Helper		Team	Score
2	Team 1	40	1		Team 1	40
3	Team 2	30	2		Team 2	30
4	Team 3	30	3		Team 3	30
5	Team 4	19	6		Team 8	27
6	Team 5	16	7		Team 7	23
7	Team 6	0	8		Team 4	19
8	Team 7	23	5		Team 5	16
9	Team 8	27	4		Team 6	0
10
11
12
Sheet10

Cell Formulas
Range	Formula
E2:E12	E2	=IFERROR(INDEX(A$2:A$20,MATCH(ROWS(A$2:A2),C$2:C$20,0)),"")
F2:F12	F2	=IFERROR(INDEX(B$2:B$20,MATCH(ROWS(A$2:A2),C$2:C$20,0)),"")
C2:C12	C2	=IF(B2="","",RANK(B2,$B$2:$B$11,0)+COUNTIF($B$2:B2,B2)-1)

 

[Fluff]

Another option for 365 & 2021

Fluff.xlsm
	A	B	C	D	E
1	Team	Points		Team	Score
2	Team 1	40		Team 1	40
3	Team 2	30		Team 2	30
4	Team 3	30		Team 3	30
5	Team 4	19		Team 8	27
6	Team 5	16		Team 7	23
7	Team 6	0		Team 4	19
8	Team 7	23		Team 5	16
9	Team 8	27		Team 6	0
Main

Cell Formulas
Range	Formula
D2:E9	D2	=SORT(A2:B9,2,-1)
Dynamic array formulas.

 

[Phyreguy]

@Snakehips, @Fluff I've entered that into a temp book to see if this will work for my application and obviously both of you are champs. I obviously need to play around using rows and other formulas. I see how this is going to work for the competition workbook as it is scored by the highest score.
As for the work application I have to have it list the person's with the least amount of hrs for a call back to the station. I've started messing with it to see where the adjustment is to have it list the firefighter with the least amount of hours up to the one with the most. I will then have to figure out how to get it to factor in when there is firefighters with the same amount of hours and have the firefighter with the most seniority to move above the other firefighter with the same hours.

 

[Fluff]

To sort column 2 low to high just change the -1 to 1