Ranking

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
 
A

abdul hussain

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
 
S

Saxman

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

I will attach very shortly.

Thanking you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking 3
Arriving at totals 2
how to solve the following in excel 1
copy and paste + transpone 3
Keep unique values 1
Paragraph numbering in Word 1
Match query 1
Staggered filter on Excel 0

Top