cell data changing when a value within a group is changed
 

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

cell data changing when a value within a group is changed
 

If the highest score is the highest number, then do it vertically.

A B
1st 60
2nd 50
3rd 40

Then, you can just enter the scores in col. B and sort col. B
only....descending.

"sandmania" wrote:

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