Home

omputing on limited values

%3CLINGO-SUB%20id%3D%22lingo-sub-847141%22%20slang%3D%22en-US%22%3Eomputing%20on%20limited%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847141%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20contains%20ss%20with%20scores%20and%20one%20that%20takes%20the%20lowest%20index's%20and%20computes.%26nbsp%3B%20What%20I%20am%20trying%20to%20do%20is%20to%20take%20the%20last%2010%20scores%2C%20and%20then%20take%20the%20smallest%206.%26nbsp%3B%20My%20problem%20is%20taking%20the%20last%2010%20scores%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESS%20with%20scores%3C%2FP%3E%3CP%3EName%26nbsp%3B%20XXXXXXX%2095%2090%2087%2096%2082%2084%2088%2085%2086%2085%2082%2081%2087%2087%2095%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESS%20using%20scores%20and%20computing%20index%20(%20what%20I%20want%20to%20do%20is%20start%20from%20last%20cell%20ignore%20blanks%2C%20and%20take%20only%20the%20first%2010%20scores.%3C%2FP%3E%3CP%3EMy%20current%20formula%3A%3C%2FP%3E%3CP%3E%3DIF('Scores%20for%20Handicapping'!D50%26gt%3B0%2C(((('Scores%20for%20Handicapping'!D50-%24D50)*113)%2F%24E50))%2C%22%20%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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))," ")