formula that will apply points to minimum numbers in a column and allow duplicate results

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.

Can you post some sample data that shows us what results you expect?

This will work with a 3 stage process, and the remainder on a fixed score. It would need to be rethought if you wanted more than just 4 scores applied to the list.

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks gak67, worked on one column but when I copied it to another column it caused a few issues and got a lot of #N/A's

Works beautifully now, small adjustment to allow for empty cells in columns, great result thanks again.

As Tony suggested, if you upload a sample file (without confidential information) we can usually suggest better solutions.

Good deal. Thanks for the feedback!