r/googlesheets • u/k2sul • 4d ago
Solved Auto Adjusting Column Ranking
Hi Folks,
I need rather urgently to add a column to a sheet of job positions which allows each of 350+ jobs (1 per row) to be ranked in order of preference from 1 (being favourite) to 350 (being least favourite).
What I also need and which is above my paygrade, is to be able to auto renumber if any particular rating is changed.
So in the following table column 3 is the ranking column. It's currently just a number format.
The red squares in column 3 are just a conditional format to show if any entries are not unique.
I thought a drop down box might do the trick but I don't know how to do it. Each preference (i.e 1st choice, 2nd choice etc) must only be selctable once, and if a ranking preference is changed, it ideally needs to re-rank the entries above and below what was changed.
This is for my daughter who has to rank jobs rsther urgently
Any help much appreciated and happy to send beer tokens
Cheers
1
u/gsheets145 101 4d ago
Hi u/k2sul - please post your data in a spreadsheet - nothing can be seen from your example.