Forum Discussion
Gareth Dunn
Jul 29, 2018Copper Contributor
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