cheryl27284
Technical User
This may be a hard one.
I have a sheet that has employee ID's,metrics and months. I want to count how many times an employee repeated the same thing but not month after month. For example, If employee 25 had "C3" for Jan and then again in Feb I don't want it to count. But if the employee had "C3" Jan, Feb, March and then June, I want it to count it as 2 repeats. Here is some sample data:
empiD Jan Feb March April May June
40020 C3 C3 C3 CFDQ C3 C3
Jan and Feb don't count becuase they are consecutive, Jan and March count as 1 repeat then March to May count as another repeat so that is 2 repeats that are not consecutive.
The purpose is to see if there is any improvement month over month.
I have a sheet that has employee ID's,metrics and months. I want to count how many times an employee repeated the same thing but not month after month. For example, If employee 25 had "C3" for Jan and then again in Feb I don't want it to count. But if the employee had "C3" Jan, Feb, March and then June, I want it to count it as 2 repeats. Here is some sample data:
empiD Jan Feb March April May June
40020 C3 C3 C3 CFDQ C3 C3
Jan and Feb don't count becuase they are consecutive, Jan and March count as 1 repeat then March to May count as another repeat so that is 2 repeats that are not consecutive.
The purpose is to see if there is any improvement month over month.