How do i count the number of times a sequence appears in a row of data

Hi Guys,

I have a row of data that I am looking at for a roster. I want to count the number of times an employee has two days off in a row over a 28 day period.

The rest days are referred to as "X" so realistically I am trying to count the occurrences where X appears twice in a row, 3 times in a row and also where it appears with no X the day before or the day after, so where the rest days are split.

Once i have this sorted my aim would then to be to count the number of times an employee has worked 5 days on and then 2 rest days. I imagine once i get the solution to the above, that will then follow through.

Any help would be appreciated.

Thanks!

Does each row have an employee identifier and then 28 columns - one for each of the 28 days?

(Also, your use of "row" is confusing bc you say "I have a row of data" but you also say "two days off in a row")

Hi James,

Sorry, by in a row, i mean twice in succession. i.e. Day 21 (Column V) would be a resting day ("X") and day 22 (Column W) would be a resting day ("X"). In column A is a list of all employees, upwards of 300 rows (one per employee), with 28 columns, one for each day.

So if there is two days in a row that have "X", I want to count that as one instance of this sequence across the row.