i want to rank these different teams without getting the same rank twice any help will be welcomed

Use a single helper value that combines all the criteria, then rank that helper with an ordinal sequence.

Assume row 3 is the first data row and:

• Points are in AG3:AG24
• Tie‑break in AH3:AH24
• 1st/2nd/3rd positions in AI3:AI24, AJ3:AJ24, AK3:AK24

1. In a free column (for example AL3) build a composite score that reflects the sort order you want (higher is better):

=AG3*10^8 + AH3*10^6 + AI3*10^4 + AJ3*10^2 + AK3

Fill this down to the last row.

2. In the Rank column (for example AM3) use RANK (or RANK.EQ) on that helper and then force an ordinal sequence by adding the count of previous equal values:

=RANK(AL3,$AL$3:$AL$24,0) + COUNTIF($AL$3:AL3,AL3) - 1

Explanation:

• RANK(...,0) ranks by the composite score (points, then tie‑break, then 1st, 2nd, 3rd positions).
• COUNTIF($AL$3:AL3,AL3)-1 increments the rank for later rows that tie on the same composite score, so the final ranks are 1,2,3,4,5… with no gaps and no duplicates.

This produces a unique, gap‑free ranking based on AG → AH → AI → AJ → AK.

References:

• RANK function
• RANK.EQ function
• WorksheetFunction.Rank method (Excel)
• WorksheetFunction.Rank_Eq method (Excel)