Column sorting, and having a "position" column
Column sorting, and having a "position" column
larrybud
Posts: 3Questions: 3Answers: 0
Hi, I have a table of data which is sports related. Let's say the first column a "position" column, 2nd column the name, and 3rd column # is "best time" and 4th column is "average time".
I'd like to be able to sort by either best time or average time, and the "position" column should be updated to reflect the position the player finished based on the sort.
If there is a tie, it needs to handle that, such that if the first two players tied for "best time", a "1" would appear next to their names, but the 3rd person on the list should be in position # "3".
What would be the proper mechanism to handle such an event?
This discussion has been closed.