Hi,
So here is a sample. Employee X was terminated, but then rehired.
I want it as follow
Before, I used to do this manually on excel. I used to do a pivot table and put "count" to reflect how many lines they have. and then do a VLOOKUP from the pivot table to get the count and if it was more that 1, I would check it manually.
Hi @AHM
It would help if you could attach the actual excel file as opposed to just a screen shot
Dan
Hi @AHM
Is this workflow work well for you?
Input :
Output :
If you have any questions, please don't hesitate to contact me.