omputing on limited values

Carlos Monssen
Occasional Contributor

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))," ")


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies