S
SamG
Hi I want to count the number of consecutive strings of text in a column
where the text string will be indispersed by something like "NA":
Seagrass
Seagrass
Seagrass
Seagrass
NA
NA
Seagrass
Seagrass
...
I want to count the number of times Seagrass appears before a break of NA's
then count the next string of Seagrass. Presumably I would have a couple of
cells as a result (in this case 4 & 2)
where the text string will be indispersed by something like "NA":
Seagrass
Seagrass
Seagrass
Seagrass
NA
NA
Seagrass
Seagrass
...
I want to count the number of times Seagrass appears before a break of NA's
then count the next string of Seagrass. Presumably I would have a couple of
cells as a result (in this case 4 & 2)