Ranking

  • Thread starter Thread starter Saxman
  • Start date Start date
S

Saxman

I have the following data in columns A, B & C. What I need to do is
assign a rank for each column.

Below is a simple example. (There are other columns and varying number
of lines).

TRPRatio LTO PenLTO
3 16 20
2.6 13 5
1.6 155 11
1.4 30 27
1.3 79 33
0.9 23 18
0.9 18 18
0.8 12 14

I need to end up with something like that below? Could it be done
without a macro?

However, if it requires code, so be it.

TRPRatio LTO PenLTO
1 6 3
2 7 5
3 1 7
4 3 2
5 2 1
6 4 4
7 5 4
8 8 6
 
YES, IT CAN EASILY BE DONE WITHOUT THE USE OF MACRO....CAN YOU PLZ SHARE THAT FILE SO I CAN DO IT FOR YOU EASILY...1
 
Back
Top