Forum Discussion
Excel programming help - which formula to automate a part of a spreadsheet
Hello I am attempting to get excel to sort a column into largest to smallest (easy part) however this task needs to be reset each time it encounters a change in ID in another columns (hard part). The...
Hi there; can't you use a RANK function to rank the kilometers and then VLOOKUP in a pre-sorted sheet?
Add a "Rank" column before the one with the name of the tile.
In the first cell, use =RANK(all column of the kilometers;first cell of the kilometers;1 or 0 depending on the order ascendant/descendant)
Then, create a new sheet with fixed numbers from 1 to N, and then use VLOOKUP to visualize the right tile in the right place.
Tricky situation is when you have same kilometers but different name of the tile ;)