Forum Discussion
terenceli35
Jun 30, 2022Copper Contributor
How to use Excel showing staff's attendance record by selected date and time?
I'm struggling in figure out how to show staff's attendance record by selected date and time in Excel. For example, we have 20 employees and I recorded which working day they attended and which ...
Riny_van_Eekelen
Jun 30, 2022Platinum Contributor
terenceli35 If you are using a modern Excel version you can probably use the FILTER function or, when the data is structured correctly you can perhaps create reports using pivot tables.