Hello there,
I have attached excel file.
For example, I have kept only two months Jan and Feb in a separate sheet. But actually, it will be in fact Jan to Dec separate sheets in the future.
When person present at work then written P and A for absent. However person name is same on all sheet, but maybe reference is not same.
In example, name ABC in Jan 18 row 3 & Feb 18 row 4.
My requirement Result sheet, in this it says Person details when he is present or absent with finding the first date and end date .
Thanks ,
Rahul
Bookmarks