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
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