Ranking highest numbers

timspin

Board Regular
Joined
Nov 18, 2002
Messages
231
Hi,

I have a feeling this should be easy -

I have a list of numbers in column a - in column B I would like to have a ranking score (1 being the highest) alongside the numbers.

I re-order them by using the sort command as the column of numbers is part of another set of data.

Any ideas??

Cheers
Tim
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

jss1234

Active Member
Joined
May 28, 2004
Messages
434
Use the formula:

=RANK(A1,$A:$A)

In cell B1

Copy and paste down
 

timspin

Board Regular
Joined
Nov 18, 2002
Messages
231
Hey Jarrod

Easier than I thought - thanks !!
Have a great Christmas
Cheers
Tim
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,686
Members
412,481
Latest member
nhantam
Top