How would I set up a table where I change a value and the table will change.
Rank Player 1 Games Pts
1 A 10 5
2 B 10 4
3 C 10 2
If I change the Pts for player B to 6 how do I have so B automatically moves to first?
How would I set up a table where I change a value and the table will change.
Rank Player 1 Games Pts
1 A 10 5
2 B 10 4
3 C 10 2
If I change the Pts for player B to 6 how do I have so B automatically moves to first?
In A2 copied down...
=RANK(D2,$D$2:$D$4)
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks