Formula Needed

Originally Posted by bigfeet59

Hello all.

As part of a team bonding excersise I have devised a pool league. I created an excel spreadsheet to show fixtures and ultimatly a table.

The table interacts with the fixtures fine . However the last part im struggling on is getting the table to alternate placing depending on points scored.

Any help with this matter would be most appreciated.

Hi,

Try the attached, but keep the Points to a Number, no decimal display to hide the Row() number included for the ranking.

hth
---