We have an unordered Excel table, where the 1^st column is the grouping column and the 2^nd column contains dates.

Task: Get rankings of rows in each group and write them in the 3^rd column while retaining the existing order of the rows. The expected result is as follows:

Use SPL XLL to do this:

=spl("=E(?).derive(#:id,rk).sort(#1,#2).run(rk=rank(#2;#1)).sort(id).(rk)",A1:B14)

E()function converts the Excel data range to a table. derive() function adds a new column. rank() function gets rankings of records in each sorted group. # is the row number and #1 represents the 1^st column.

Source:https://stackoverflow.com/questions/78109251/how-to-create-a-sequence-number-based-on-sales-agent-name-and-sale-date-in-excel