2 Replies Latest reply on May 13, 2017 5:00 PM by Christoph Wolf

# Combined Table Rank - how?

Hello!

I'd like to rank according to three criteria to get a properly ranked soccer table (just like here):

1. points (Punkte) - descending

if points are equal look at

2. +/- - descending

if points and +/- are equal look at

3. goals (Tore) - descending

I tried this formula (STR(RANK(SUM([Punkte_gesamt])))+ "-" +STR(RANK(SUM([Tordifferenz]))))+ "-" +STR(RANK(SUM([Tore_gesamt]))) but i did't work since "Tordifferenz" and "Tore_gesamt" were rank the wrong way (ascending)

Any ideas and help appreciated!

Thanx

Christoph

• ###### 1. Re: Combined Table Rank - how?

Hi Christoph

Here is one idea. Assuming number of team is less than 100, three Rank can be combined as following instead of using STR.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Combined Table Rank - how?

Thanks Shin,

that worked well for me. Seems to be a smart way to create a weighted rank.

Best

Christoph