sorting order

  • Thread starter Thread starter Goldie
  • Start date Start date
G

Goldie

How could I define a series of results in a sheet if I wanted to do like a
first place second place third place and so on from data with names in one
column and data in the next column.
I am not wanting to use the sort function to move the data around I merely
want a column, say to the left of the names, stating their position in the
table.

Using the list below I would have Stan as 1, Sue and Bill as 2, Steve as 4
and so on.
Tom 1
Bill 10
Kev 8
Andy 4
Fred 5
Stan 16
Rob 7
Eddy 8
Steve 9
Sue 10

Is this at all possible or am I using a hard route to get the desired
information?

Any help is appreciated.

Andrew Goldstein
 
Goldie

With the lists below in column B and C

In A1 enter =RANK(C1,$B$1:$B$10)

Drag/copy down column A.

Note: duplicates get equal ranking.

Bill and Sue get a 2 but there would be no 3. Next would be Steve at 4.

See Help on RANK Function for more on ordering the rankings.

Gord Dibben XL2002
 
Hi Goldie,
Embellishing on Gord's reply, it mitght be nice to identify the four
people who are tied by using COUNTIF..

Placing two columns in front (A for Ties, B for Rank), and a header row at top.
A2: =IF(COUNTIF($B$2:$B$11,B2)>1,"*","")
B2: =RANK(D2,$D$2:$D$11)

You can sort the table on Rank as follows:

Select cell B2 or any cell in the column to be sorted.
Ctrl+A -- the Cell B2 should still be the active cell and all cells should be selected.
invoke Sort with the Ascending Sort toolbar button.
---
 
Thanks for that

Goldie


Gord Dibben said:
Goldie

With the lists below in column B and C

In A1 enter =RANK(C1,$B$1:$B$10)

Drag/copy down column A.

Note: duplicates get equal ranking.

Bill and Sue get a 2 but there would be no 3. Next would be Steve at 4.

See Help on RANK Function for more on ordering the rankings.

Gord Dibben XL2002
Click to expand...
 
Back
Top