Forum Discussion
Solved
Calculate hours Percentage of different employees with variable total (long employees list)
Hi all, Is there anyone who can help me to overcome this issue. I have a large employees list and I would like to Calculate hours Percentage of different employees with variable total. Employee...
Please see screenshot for reference. I would try using an Hlookup with a few reference numbers that are set up based on the number of repetitions:
=HLOOKUP(I8,$E$9:$G$10,2,TRUE)
Please see the attached file for reference. It looks like you are receiving some type of standard payroll report. If you have any influence on the report format I have attached the ideal report output that would allow you to easily accomplish your task. If you can get a report in that format then you can use a simple pivot table to get to your end goal. Otherwise, I have attached a few formulas that will work for your current set up:
