Hi - I'm brand new to the forum but know there is someone that can help..
I have a problem and I found a good explanation of something similar here:
http://www.excelforum.com/excel-gene...-a-column.html
In the original posting the following formula solves the problem (attached) TestData.xlsx
B1: =AVERAGE(INDEX(B3:B100,MATCH(TRUE,B3:B100<>0,0)):INDEX(B3:B100,MATCH(TRUE,B3:B100<>0,0)+4))
What I would like to return is the average of the 1st 5 values, but what if a number of cells after the first value were also blank
I hope this makes sense and hope you can help
Thanks
Bookmarks