Count rows sequentially, where it recounts again when a undesired input was given.

[saman018]

Does anybody know how to make excel count rows sequentially. Where if there is a different text, it will stop counting to that number until a desired text is given?
like for example at A2 to F2, has two possible letters to be inputted. First excel counted 2 As from A2 to B2, however it stopped because B was inputted. Then finally it counted 3 As from D2 to F2.
It can vba or formula.
Thank you very much in advance.

 

[Eric W]

How do you want the results displayed? Here's one option:

Book1
	A	B	C	D	E	F
1	Monday	Tuesday	Wednesday	THURSDAY	FRIDAY	SATURDAY
2	A	A	B	A	A	A
3
4	1	2	1	1	2	3
Sheet2

Cell Formulas
Range	Formula
B4:F4	B4	=IF(B2=A2,A4+1,1)

 

[saman018]

THANK that works like a charm, i needed to tweak it a bit to fit all my conditions, but you lead me to the right path of thinking. Do you happen to know if there is a formula for conditional formatting that indicates if the count reaches to the value of 4 then the cell next to it (at the main row) needs to be highlighted.

 

[Eric W]

Maybe:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Monday	Tuesday	Wednesday	THURSDAY	FRIDAY	SATURDAY	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday
2	A	A	B	A	A	A	A	B	B	B	B	B
3
4	1	2	1	1	2	3	4	1	2	3	4	5
Sheet2

Cell Formulas
Range	Formula
B4:L4	B4	=IF(B2=A2,A4+1,1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:N2	Expression	=A4=4	text	NO