Sep 10 2019 10:11 AM
I have a workbook that contains ss with scores and one that takes the lowest index's and computes. What I am trying to do is to take the last 10 scores, and then take the smallest 6. My problem is taking the last 10 scores
SS with scores
Name XXXXXXX 95 90 87 96 82 84 88 85 86 85 82 81 87 87 95
SS using scores and computing index ( what I want to do is start from last cell ignore blanks, and take only the first 10 scores.
My current formula:
=IF('Scores for Handicapping'!D50>0,(((('Scores for Handicapping'!D50-$D50)*113)/$E50))," ")