sorting order

[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

 

[Gord Dibben]

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

 

[David McRitchie]

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

 

[Goldie]

Thanks for that

Goldie

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

 

[Gord Dibben]

Appreciate the feedback Goldie.

Gord

Thanks for that

Goldie