Dec 20 2021 07:54 PM - edited Dec 20 2021 07:59 PM
Hi All,
I have a massive spreadsheet which I run on a weekly and monthly basis. The data represents time worked by employees on each job. Therefore, each employees can have many lines for a single day.
The start and end dates for the report required are in cells D1 & E1 respectively. Based on these dates, I have column AV displaying whether the line is TRUE (ie., within the date range) or FALSE (ie., not in the date range).
I am able to find the hours worked within the date range in each area for employees and contractors using sumifs (see rows 3 to 10). However, I also need a headcount (based on Column AM). The problem is that the same employee/contractor can show up many times and I only need to count them once showing which work area and whether they are a contractor or employee.
Can anyone help? I have attached a sample sheet for your ref.
Dec 21 2021 05:52 AM
You attached an image rather than an actual sample Excel spreadsheet. If you are able to post an actual sheet, make sure it doesn't include the names or other identifiable info on any real people--use fake names.
In the absence of an actual sheet, here are some ideas:
Dec 21 2021 01:20 PM
Hi,
Thanks for getting back to me. How do I attach a spreadsheet? I've already got rid of all the identifying information.
Cheers,
Danni
Dec 21 2021 01:24 PM
If you open the full text editor, then down below it you should see this area where you can drag and drop your file(s)
If that doesn't work, click on my hyperlinked name and send me a private message and attach your file there.