-
If not by color, then can the counter be triggered by a number or a text. for e.g,In my attached workbook, the first sheet is named as counter. In this sheet, Column E contains header called condition & the cells below either has text "TRUE" or number "1" in it. I know i can use count if condition to get the number of "1s" in between true but the problem is the data is never constant, i mean TRUE & 1 can be in any cell in that particular column and I specifically the count of "1s" between 2 "true" cells.
-
The Function in my previous post looks at the cells in Column 1 to do that, Enter that code in a standard module and enter
=IF(LEFT(A2,2)<>"BB",ClrCount(A2),"")
in Row 2 and copy down.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
I tried the function & it works brilliantly on an individual sheet (like the one i have pasted here)but there is a slight hindrance. This sheet is part of a macro enabled workbook, which i have made partly by recording macro & partly by adding codes. It allows me to add the code & the formula (=IF(LEFT(A2,2)<>"BB",ClrCount(A2),"") only in 1 cell. the moment i try drag the formula in the entire column, the workbook freezes & excel file is unresponsive. I have to forcefully exit the workbook. Am i missing some logic here or this code wont work with another macro enabled workbook. Also pardon my knowledge and sorry to sound like an oaf but can the count of cells be obtained without code and only by formula.
-
I suggest you mark this as solved post this part as a new question to get more input.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote
