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