Good Morning,

I'm new to this forum, so hope I'm doing this correctly.

I have a spreadsheet with golf results in one column and I want to apply points to the lowest score, second lowest, third lowest etc, however the formula I'm playing with creates an issue when there are duplicate scores, eg, if the lowest score = 100 points, second lowest = 75, third lowest 50 and all remaining scores get 25 points. formula works perfectly until there are two scores the same, eg, both receiving 100 points, then the 75 points disappear???

formula currently looks like this:

=IF(F3=SMALL(F:F,1),100,IF(F3=SMALL(F:F,2),75,IF(F3=SMALL(F:F,3),50,25)))

I need to be able to have multiple results of each score, but have no idea how to achieve this.