Hi, I have a report of employee IDs that contain information regarding those employees across a 98 day period. There is one row per employee per date, so one employee ID may have up to 98 rows of data but may have less.
Let’s say I have a second tab that removes duplicate Employee IDs and contains just a column of unique Employee IDs. If I wanted to add a column to the second tab that contains either a “Yes” or a “No” depending on whether there were any 10 consecutive weekdays of rows for the given Employee ID on the first tab, what is the best way to set that up?
Let’s say I have a second tab that removes duplicate Employee IDs and contains just a column of unique Employee IDs. If I wanted to add a column to the second tab that contains either a “Yes” or a “No” depending on whether there were any 10 consecutive weekdays of rows for the given Employee ID on the first tab, what is the best way to set that up?