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

 

[PaddyD]

Thanks for jumping in, Aladin. Now I'll have to go off & reflect on why that didn't occur to me when I had a look (it being quite late and a few glasses of wine later is some, but not all of the reason!)

 

[slam]

Thank you to both of you. Might I ask for some help on post #19?

Thanks

 

[Aladin Akyurek]

Thank you to both of you. Might I ask for some help on post #19?

Thanks

Care to elaborate on ">/= 15"?

 

[slam]

Care to elaborate on ">/= 15"?

In the image above, I just need to count the highest number of consecutive instances where the value is >/= 15 (so basically the 15, 18, 25 values), so in the first row it would be column F through N, the second row would be F through P, the third row would be N through R, and so on.

 

[Aladin Akyurek]

In the image above, I just need to count the highest number of consecutive instances where the value is >/= 15 (so basically the 15, 18, 25 values), so in the first row it would be column F through N, the second row would be F through P, the third row would be N through R, and so on.

Control+shift+enter, not just enter:

=MAX(FREQUENCY(IF(ISNUMBER(F2:X2), IF(F2:X2 >= 15, COLUMN(F2:X2))),
  IF(F2:X2 < 15, COLUMN(F2:X2))))

 

[Aladin Akyurek]

Thanks for jumping in, Aladin. Now I'll have to go off & reflect on why that didn't occur to me when I had a look (it being quite late and a few glasses of wine later is some, but not all of the reason!)

More likely preoccupied mind and wine helping... By the way missed the February events but a study trip with students to Istanbul is underway...

 

[PaddyD]

"...trip with students to Istanbul is underway."

Very jealous - I'm still stuck in the northeast with no passport

 

[slam]

Control+shift+enter, not just enter:

=MAX(FREQUENCY(IF(ISNUMBER(F2:X2), IF(F2:X2 >= 15, COLUMN(F2:X2))),
  IF(F2:X2 < 15, COLUMN(F2:X2))))

This doesn't seem to be handling the -'s, DNF's etc. It's giving be a result of 11 for the first row and 13 for the 2nd row. The results should be 9 and 11 respectively.

 

[Aladin Akyurek]

This doesn't seem to be handling the -'s, DNF's etc. It's giving be a result of 11 for the first row and 13 for the 2nd row. The results should be 9 and 11 respectively.

You seem to overlook your specs: >=15 reads like "only numbers and those which are greater than or equal to 15.

Are you wanting: Not DNS or "-" or any number less than 15?

 

[slam]

You seem to overlook your specs: >=15 reads like "only numbers and those which are greater than or equal to 15.

Are you wanting: Not DNS or "-" or any number less than 15?

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