Count blocks of cells that have a meet a ste value,
I have a speardsheet that contains a column (F9:F1500) with blocks of zeros's, one's, & two;s. I need a formula that looks up the column (F1500:F9) to find and count the cells in the first block of one's, and ignore any other blocks containing one's.
Thanks.
Not clear what do you mean by BLOCKS and how you are identifying each BLOCK
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixthsence,
By BLOCKS, I mean continuous cells with the same value (one's).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks