Ranking By Score on Import

[Qiro]

Is there a way to rank n rows in a CSV import based on column values?

ID	Week	Name	Score	Rank
000001	7	Joe Bloggs	62	??
000002	7	Jane Doe	71	??
000003	7	John Smith	68	??

I need to automatically populate the [Rank] column based on the [Score] column, but the CSV is being imported into a large, pre-populated sheet, so I can't rank based on all values. They can be differentiated by [Week], but the Week value will change with each new CSV upload so I can't specifiy a value for that column.

Any help would be appreciated!

[Suvrutt_Gurjar · Accepted solution]

As per my understanding, you may need to use either of two options

1. Add the rank before the CSV is uploaded. This means computing and adding the rank in the CSV file itself. 

If this is not feasible, then you could do the following

2. You could have a reference action or a bot that changes the rank for all the latest added rows for a week. This bot or action may need to be manually invoked once the CSV upload is done.