Search results

Sajan I have elevated you to Legend status. Thank you so much - it works. Peter

Sajan You are exactly correct with your description. I am getting an error in the result/formula cell #VALUE! Peter

Narayan (Ninja) My raw data is 200 competitors who may or may not compete on a given day. Their score is expressed as a % of the winner. I need to take the last actual 8 %'s and average them. My data is arranged from oldest to latest left to right, with each competitor a different row. The...

Thanks The only issue is that it seems it averages the 8 inclusive of a Nil result,so it may be average 5 scores (and 3 blanks), rather than selecting the 8 scores and ignoring the blanks.

Thanks Narayan The data is in a row in separate columns. Essentially we have rows of competitors and columns are the score of those who competed. The winners scores becomes 100% and all others competing a percetage of their score. eg: Winner achieves 149 out of 150 - that becoimes 100%...

Hi Peter here. I have a range of results for a sporting competiton. We need to average up to the last 8 results which are displayed in rows. Some competitors will have 4 results some will have 20 - I only want to average each competitors most recent 8. Eg: result - oldest to latest Person...