Hello Domenic,
You Champion!
Thank you, what I did was build a table to use the same cell references that
you had in your formula's and the formula's work perfectly.
Now I will adapt the formula's to my tables accordingly.

Well done and than you again.

Best regards

Max

"Domenic" wrote:

Did you adjust the references accordingly?

Did you confirm the formula for the second approach with
CONTROL+SHIFT+ENTER, not just ENTER?

In article ,
Max wrote:

Hello Domenic,
How do I attach an Excel spreadsheet, I will send it to you. May be this
will help.

For some or other reason I am missing it with the formulas you sent me.
I still get numbers, I need to be able to display the team names according
to the three ranking criteria.

Thank you for your help.

Max