In column C2:C5000 I have a list of 20 different names in random orders and different occurances. In column E2:E5000 the same 20 names are randomly listed in different occurances, but not when it occurs in column C.
I need a formula that will return the most consecutive times a particular name occurs in column C before it occurs in column E.
My crude example ...
-C---E
blu grn
red yel
red yel
grn red
red blu
red blu
red grn
yel blu
blu grn
red yel
grn red
red grn
The most consecutive times red occures in column C before it occures in column E is 4 times
Thanks, John
I need a formula that will return the most consecutive times a particular name occurs in column C before it occurs in column E.
My crude example ...
-C---E
blu grn
red yel
red yel
grn red
red blu
red blu
red grn
yel blu
blu grn
red yel
grn red
red grn
The most consecutive times red occures in column C before it occures in column E is 4 times
Thanks, John