Hi, I am trying to make a comparison against a set of data and rank them accordingly. The data can comprise up to 150 rows.
I compare data in column 1, get the ranking from there and if there is a tie for certain rows, I compare data on column 2 only for the rows that are tied. This is repeated until there is no more tied data or until all the columns have been exhausted.
I have attached the sample data and also the expected answer for easy reference. Thank you in advance to anyone who can help with this.
I compare data in column 1, get the ranking from there and if there is a tie for certain rows, I compare data on column 2 only for the rows that are tied. This is repeated until there is no more tied data or until all the columns have been exhausted.
I have attached the sample data and also the expected answer for easy reference. Thank you in advance to anyone who can help with this.