Forum

I was able use the FILTER function to obtain the correct result in my spreadsheet. Thanks.

Here is an example file

I changed the formula to =-SUMIFS(Table1[Hours_Worked],Table1[Code],B5,Table1[Year],A2,Table1[Pay_Multiple],A1) and I received the correct result ...

Riny, Employees get different types of leave in the USA. The leave I'm trying to calculate is a special Federal Government mandated leave. It is in ...

Although a weekly calculation, there is carry forward. As an example week 1 an employee works 40 hours. For the first 30 hours the get 1 hour of S l...

Thank you Anders. I have to digest what you wrote. I did follow Mynda's link to the Let function. I'm learning for sure.

Mynda, Thank you so very much. After 2 months and a block of time set aside, I was able to use your suggestion to make it work flawlessly. I followe...

Riny, thank you. I made a few attempts and then was able to do it. I believe that finishes this task. On to another. Plus finish going through all...

Thank you Thank you!!!! Yay, that worked perfectly. I have one more problem to add complexity to this model but I'm almost completed the task I've...

thank you Riny for the help. I haven't finished watching the power pivot video training to see how it integrates with query editor. I do not see the...

Riny, With regards to, "Then, you do a little bit more cleanup to get rid of columns from the Personnel table and rename some in the PayrollExport ...

I will review the spreadsheet. Thank you so very much.