Hi,

I have a sheet where there are several scores within one row.each column
represents a different persons score.

These scores are ever-changing. Above this row, I enter 1st,2nd,3rd,4th
depending on what place the score is in.

what i currently do, is when i change one score, I have to change the 1st,
2nd field for each column. this becomes a pain.

What I would ideally like is when I change one score, it checks against the
other scores and then assigns what position it is in. Then in turn, it
changes the position for the other scores, so that no one score has the same
position i.e each score in its own position.

sounds complicated, but I think its just the way I have explained.

Any help would be appreciated.
thankyou