Going back to this topic:
I need something similar again, but this time I cannot sort table.
So I use formula:
Col Rank( Round( :Column ), :Category, <<tie( "minimum" ) )It gives me column filled with the following values: {1, 114, 340, 453, 1018, 1131, 1357}
I need to turn them into {1, 2, 3...} and so on.
One idea is to construct Associate Array where a key would be a position of the number, and the value would the same number, and then use it create a column I need. Any other suggestions?
@jthi - any suggestions?
If you don't need a formula, Summary table can usually be used to calculate the ranks and then you can use Update to add them back to your original table.
... you just have to wait for col order() aka col score():