Posté le: Ven 6 Oct - 08:19 (2017) Sujet du message: Official discussion Open!!!
I am trying to make a dynamic employee tracker for attendance. I have attached a sample workbook.
The workbook has: Employee Name, Vacation Used, Sick Days Used and Care Days used on the first sheet to summarize the info. The second sheet has the input data. Employee Name, Attendance Type, Start Date and End Date. I used data validation and named ranges to have drop downs for the first two columns.
Essentially, I am experiencing a situation in which a person may have a.
I have tried a number of combinations using Counter, sumproduct, Index, If, Index Match, etc.
The formula I am attempting to find any new entries.
Please help. Thanks!
I did not find the right solution from the Internet.