# How to add the NUMBER to the record after SORTING

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.

edit retag close merge delete

Hi, if you use LO calc, you could try the RANK function.

( 2019-11-01 13:27:17 +0100 )edit

Sort by » oldest newest most voted

Use the RANK() function with the optional third parameter = 1

more

Thank you. I've just found that function.

( 2019-11-01 13:36:35 +0100 )edit