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.