Count Consecutive Cells Containing specific text?

[slam]

Let's say in F2 to X2, I sometimes have the text DNS. In AN2, How can I count the consecutive instances of DNS?

Thanks

 

[Aladin Akyurek]

Right, DNS, DNF, DSQ, - should all be treated the same as 0-14, i.e. not included.

So, you want to exclude DNF and DSQ too...

Control+shift+enter, not just enter:

=MAX(FREQUENCY(IF(1-ISNUMBER(MATCH(F2:X2,
 {"DNS","DNS","DSQ","-"},0))+(ISNUMBER(F2:X2)*(F2:X2>=15)),
  COLUMN(F2:X2)),IF(ISNUMBER(MATCH(F2:X2,
   {"DNS","DNS","DSQ","-"},0))+(F2:X2<15),COLUMN(F2:X2))))

 

[slam]

Thank you, that works great!

(You had DNS in there twice (missing DNF), and that caught me out for a minute before I noticed). Thanks!

 

[Aladin Akyurek]

Thank you, that works great!

(You had DNS in there twice (missing DNF), and that caught me out for a minute before I noticed). Thanks!

You are welcome. Thanks for providing feedback. Just a minute, that's not too bad...