Hi Everyone:
I have a huge data set of timesheet entries, and I want to calculate the employee headcount in each week. I've attached a simplified example. Each entry has data for the "Week #" and "Week Of". I need a formula that will look at either the "Week #" or "Week Of", and figure out how many unique employees there are within each period. I can gather the totals in a pivot table, so if the formula could count only one occurrence of each name for each pay period, and ignore the rest of the occurrences, that would be great. Maybe mark the first occurrence with a "1" and the rest with a "0" in each period?
Any help would be greatly appreciated.
Thanks!
Bookmarks