Helo Everyone!
I have interesting case - maybee someone will have a smart solution.
What I want to do:
- Compare the list of employees that should not work in a particular day (holiday/sick leave/whatever) with the list of persons that actually logged-in to the IT system.
It would be simple to use v.lookup if we would have one name, one date and other list with IT-log but imagine that you have 100 emps and all of them can have several periods/dates when they were absent.
Example in the file:
- "Absences" includes information from HR department,
- "Log" specifies when employees actually worked in the system
I finally found some solution but it is time consuming and requires a lot of copy-pasting
Bookmarks