Awarding prizes in column 'D to list of scores in a column 'C'

[zircom]

Hi,

i have the follwing and wish to award a value to the highest points for the top 4

Col 'A' Col 'B'
Points Prizes
23 € 0.00
35 € 0.00
33 € 0.00
28 € 0.00
38 € 0.00
18 € 0.00
22 € 0.00
27 € 0.00
30 € 0.00
30 € 0.00
36 € 0.00
40 € 0.00

Thanks

 

[SkipVought]

Hi,

Check out the AutoFilter, CUSTOM criteria feature.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[zircom]

hi,

i want it to do the winnings automatically.

Ie:

once all the scores are in Column 'D' is completed by a formula as to who has one what. I assume i am going to have a table some where as well.

Thanks

 

[SkipVought]

Well you did not ask for that.

Please be clear, concose and complete.

sort by the order you wish.

Use the CHOOSE function.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[AnotherHiggins]

formula solution (without sorting):
[tab]=IF(RANK(A2,A:A, 0)<=4, "award", "")


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[GSCaupling]

Are you trying to award the same value to each of the top four, or different values? How do you want to deal with ties?
GS

[small][navy]**********************^*********************
I always know where people are going to sit. I'm chairvoyant.[/navy][/small]

 

[zircom]

i am wanting to award different amounts = £50, £40, £30, £20

ties share the 2 places

thanks