rank
 

hi guys sorry to seem thick i have a very very basic knowledge of excel, but
am in the proces of doing a fantasy F1 competition, i have managed to do all
other formula's no worries, i am stuck on the final one, though.

i have in columns W6:W17 the final totals, what i am after is in column
Y6:Y17 i wish to place a ranking of first second third in order of who has
the highest points i have read some of the responses on other questions but
am totally TOTALLY lost...

please help......

rank
 

=LARGE($W$1:$W$7,ROW())

Copy down 17 rows.


--
Kind regards,

Niek Otten

"jonboy4969" wrote in message
...
hi guys sorry to seem thick i have a very very basic knowledge of excel,
but
am in the proces of doing a fantasy F1 competition, i have managed to do
all
other formula's no worries, i am stuck on the final one, though.

i have in columns W6:W17 the final totals, what i am after is in column
Y6:Y17 i wish to place a ranking of first second third in order of who has
the highest points i have read some of the responses on other questions
but
am totally TOTALLY lost...

please help......

rank
 

JonBoy4969

Ok. I think this will work.

In W6:W17 you have final scores. In Y6:Y17 you want the scores to be ordered
such that the highest score is in Y6, the second highest in Y7 etc.

In Y6 type the following formula and drag down to Y17:

=LARGE($W$6:$W$17,ROW(W6)-5)

LARGE returns the kth largest value from a range and takes two arguments.

The first is the data range i.e. your final scores.

The second states which value we want e.g. the first highest, second highest
etc. Here you take the row value of W6 i.e. 6 and then minus 5 to give 1.
This tells the formula to return the highest value. For W7 it takes 7 - 5 to
give 2 so you get the second highest value etc.

This will order your socres.

Happy trails...

Alex

"jonboy4969" wrote:

hi guys sorry to seem thick i have a very very basic knowledge of excel, but
am in the proces of doing a fantasy F1 competition, i have managed to do all
other formula's no worries, i am stuck on the final one, though.

i have in columns W6:W17 the final totals, what i am after is in column
Y6:Y17 i wish to place a ranking of first second third in order of who has
the highest points i have read some of the responses on other questions but
am totally TOTALLY lost...

please help......

rank
 

If you want to construct a Top 3 list, based on the final totals, see my
post in:

http://www.excelforum.com/showthread.php?t=333697

jonboy4969 wrote:
hi guys sorry to seem thick i have a very very basic knowledge of excel, but
am in the proces of doing a fantasy F1 competition, i have managed to do all
other formula's no worries, i am stuck on the final one, though.

i have in columns W6:W17 the final totals, what i am after is in column
Y6:Y17 i wish to place a ranking of first second third in order of who has
the highest points i have read some of the responses on other questions but
am totally TOTALLY lost...

please help......

rank
 

CHEES GUYS, TRIED THE ANSWERS YOU GAVE AND THEY WORK WONDERFULLY, HAD TO
TWEEK A COUPLEO F BITS BUT IT WORKS.

WELL PLEASED

THANK YOU

JON