Count maximum consecutive characters within a range of cells that meet a criteria

[eat at joe's]

Similar question to one asked recently:

I would also like to be able to find the maximum consecutive occurrences of "." for each person when results are combined with previous entries. For example, Tom's first result finishes with 4 consecutive "." When combined with his second result which begins with one "." before an "x" the formula result should be 5. (see below)
One person may have 100 different entries. I just need the single maximum consecutive occurrences of "." for each individual when spread across different rows.

John .xxxx
Mary ..x...
Lisa ...xx
Tom .x....
John x.....
Tom .x.xx.
Lisa x.x..x
Mary ......

Thanks

 

[Akashwani]

Hi,

I don't think this is the best solution for you, but in the absence of an experts solution will this work for you?....

Excel Workbook
	A	B	C	D	E	F
1	Name	Number	Helper	1	Name	Total
2	Tom	123	1	*	Tom	4
3	****	223111	3	*	****	8
4	Harry	125	1	*	Harry	6
5	Sally	126	1	*	Sally	3
6	Bill	127	1	*	Bill	3
7	Bob	222	0	*	Bob	5
8	Jo	129	1	*	Jo	3
9	Joe	321234	1	*	Joe	5
10	Tom	131	2	*	*	*
11	****	132	1	*	*	*
12	Harry	11133	3	*	*	*
13	Sally	134	1	*	*	*
14	Bill	135	1	*	*	*
15	Bob	6111136	4	*	*	*
16	Jo	22137	1	*	*	*
17	Joe	21121	3	*	*	*
18	Tom	22221	1	*	*	*
19	****	551112221	4	*	*	*
20	Harry	141	2	*	*	*
21	Sally	142	1	*	*	*
22	Bill	143	1	*	*	*
23	Bob	144	1	*	*	*
24	Jo	145	1	*	*	*
25	Joe	146	1	*	*	*
TestData

I'm sure that it is possible to put both formulas into 1 Sumproduct, but I can't get my head around it, sorry.

D1 has the criteria to count.
Change the range of your data in the formulas in B2, F2 and copy down as far as is required.

Good luck and I look forward to seeing the experts solutions.

Ak