Hi folks,
I'm new to this forum to appolgies if I make any newbie mistakes. The problem I have in Excel 2007 is:
1. I have a range runnin down column B as below:
ROW COLUMN B ROW COLUMN D (derived from results of column B)
1 0 3 1
2 0 5 3
3 1
4 0
5 3
6 0
etc
What I want to end up with is a function that looks at cell B1, realises it's a zero and counts the number of zeros until it comes across a non-zero and displays that. The in the next cell down it starts at the whole number the previous cell found, and repeats the process of counting zeros utnil the next whole number is found, and on, and on..etc
I've already spent qutie a while on this and am getting nowhere so any helpful suggestions welcome!
Bookmarks