In the attached workbook I have a couple columns of values that are either 1 or 0. I need a formula that will count the number of times 1 occurs 2 times consecutively in each column. If there are four 1's in a row that would count as 2 for example.
In the attached workbook I have a couple columns of values that are either 1 or 0. I need a formula that will count the number of times 1 occurs 2 times consecutively in each column. If there are four 1's in a row that would count as 2 for example.
Last edited by rmb623; 08-09-2011 at 02:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks