Hi all,
Is there any option to add a NUMBER/INTEGER value to the record after sorting?
it could be done in BASE or CALC, whichever is possible
Here is what I am trying to do:
- I have a table of records with many columns.
- Let’s say it is a table with contestants (for example runners)
- the runners are running on 3 different distances, thus obtaining 3 differend results i 3 different colums (let’s call them “time1”, “time2” and “time3”)
- I would like to sort the table using the “time” columns and specify a position for each runner in each of the three runs. (lets say the positions will be shown in columns called “score1”, “score2” and “score3”)
- for exaple runner1 in column “time1” have the best result so he should have NUMBER/INTEGER “1” in the column “score1”, but he is not very good in long distances so he has the worst result in column “time3”, thus should have the NUMBER/INTEGER “40” in the column “score3” (aasuming there are 40 runners)
- Thus the values in columns “score” should be updated automatically depending on the number of participants.
- It also should update while adding new values to “time” columns.
Once again. the solution could be for BASE or CALC. I cannot figure it out in any of those programms.
Thank you for any advice.
.