Forum Discussion

Gareth Dunn's avatar
Gareth Dunn
Copper Contributor
Jul 29, 2018

Count occurance of specific sequence across two cells in a worksheet

Hi I am looking to count the occurance of a set seqeunce occuring across two cells. THe information relates to employees shifts times. Start and end times are in one cell and each day is recorded below the other (i.e. one column per employee). _ could transpose this to show one employee across one row with days in different columns?

 

See attached book with extract for data. Example. I want to count the number of times the shift L 10:00 AM - 10:00 PM (D6) is followed by the shift E 7:45 AM - 4:45 PM (D7).... across a much larger spreadsheet

No RepliesBe the first to reply

Resources