Forum Discussion
robywoo
Jun 17, 2022Copper Contributor
Excel Formula for Comparison
I have this spreadsheet of employees who work either 6 hours or 2 or 3. With 6 being a full day and 2 or 3 being part days. I need to find out for each employee whether the days that they worked were...
Riny_van_Eekelen
Jun 17, 2022Platinum Contributor
robywoo I would create a simple pivot table as in the attached file, summarizing the number of days for each number of hours (2, 3 or 6).
robywoo
Jun 17, 2022Copper Contributor
Thanks Will give that a try