Points based upon Rank Scoring

[bluenose5709]

Hi,

I am trying to allocated points against the positions achieved in a competition

Column E is a simple yes no field and Column F will be manually populated

I would like for Column G to allocate points:

1 = 6
2 = 5
3 = 4
4 = 3
5 = 2
6.... Every place from 6th who participated would receive 1 point

can anyone help with the formula to make this work..?

thank you

 

[Fluff]

How about

=IF(F6="","",XMATCH(F6,SEQUENCE(6,,6,-1),-1))

 

[bluenose5709]

Fluff,

Perfect,

thank you

 

[Fluff]

You're welcome & thanks for the feedback.