Max frequency for consecutive text multiple condition

[yogeshDD]

Hi

I need the formula for max frequency or similar to this, Problem statement is - I have an attendance record of 1 month in which I need to calculate a repeated occurrence. let's say.. if Mr. ABC is present (P) from 1-April to 7 April, and then on his Week off day he was present then the outcome for the present should be 8.

I'm using this formula but it is giving me output only for P

ArrayFormula((MAX(FREQUENCY(IF(B2:H2="P",COLUMN(B2:H2)),IF(B2:H2<>"P",COLUMN(B2:H2))))))

Name	1 May	2 May	3 May	4 May	5 May	6 May	7 May	Total P (Consecutive) Result	Total P (ConsecutiveP+WOP) final result
ABC	P	P	P	WOP	P	A	P	3	5

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Name	01-May	02-May	03-May	04-May	05-May	06-May	07-May	Total P (Consecutive)	Total P (ConsecutiveP+WOP)
2	ABC	P	P	P	WOP	P	A	P	3	5
Main

Cell Formulas
Range	Formula
J2	J2	=MAX(FREQUENCY(IF(ISNUMBER(SEARCH("P",B2:H2)),COLUMN(B2:H2)),IF(ISERROR(SEARCH("P",B2:H2)),COLUMN(B2:H2))))
Press CTRL+SHIFT+ENTER to enter array formulas.