I have weekly employee lists of names for each weekly pay period. I am trying to compare the lists to see which names are new from week to week. How do I do this?
I have weekly employee lists of names for each weekly pay period. I am trying to compare the lists to see which names are new from week to week. How do I do this?
When a new employee is added to the list, have something in excel to record the date that this entry was made. When checking 'who's new?' on the sheet, check all entry dates that are within a week old. Those would be your
new entries of the last 7 days.
Add a column beside new lsit
Type the following formula ( change to your range)
copy down to all the rows have a namePlease Login or Register to view this content.
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks