Hi All,
I have one more question this week, apologies. So in the attached: in 'Payroll File 2023', I need to populate column F9:F27, G9:G27, etc. based on a period/week number selection in B4. The data is taken from sheet called 'Construction - Payroll Hrs 2023'. So if I select PERIOD 10 wk18 for Employee ID 1, I should see number 2 for OT 1.5 and 1 for Employee ID 2. If I select PERIOD 10 wk19, I should be able to see number 3 for ID 1 and 4 for ID 2.
Thank you.
L.
Hi there,
in cell F9 try:
Formula:
Please Login or Register to view this content.
For cell G9 update the last bit of the offset function from 19 to 20.
Let us know if that works.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
Thanks so much, Roos. That worked perfect.
L.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks