I need to calculate the average of the first ten real results in a series of 30 numbers - some will be blank.. the first ten in the series from left to right and ignore any numbers post teh first ten results taht appear - there will be several blanks in the series and multiple series with lots of blanks. If there are not ten signalled numbers in the series then the average of what is there ,ie 8 /9 etc.
| item | result? | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | |
| figures | 1.8% | 16.0% | 8.3% | 1.4% | -2.2% | 13.2% | -11.7% | 3.9% | 10.4% | 19.5% | -13.1% | 4.1% | 6.5% | -8.2% | 23.0% | 9.8% | 4.2% | 14.9% | 5.9% | 7.8% | 1.2% | 1.3% | 6.9% | |||||||||
| figures | 5.9% | 20.1% | -3.8% | -0.1% | 24.1% | 3.8% | 13.4% | 12.6% | 82.3% | 4.9% | 10.4% | 8.0% | 0.0% | 1.6% | 5.5% | 22.7% | 22.9% | -3.6% | 9.5% | |||||||||||||
| average of first ten results that arent blank? | ||||||||||||||||||||||||||||||||
| if less than ten then whatever the number | ||||||||||||||||||||||||||||||||
