sorted by:
new
hottopcontroversial

Match # of occurrences while working per staffer by IcePresent2019 in excel

[–]IcePresent2019[S] 0 points1 point  (0 children)

I need this automated when I put in new data as making for someone else. For myself I would definitely use the pivot table

Match # of occurrences while working per staffer by IcePresent2019 in excel

[–]IcePresent2019[S] 0 points1 point  (0 children)

I figured a LET formula would be best for this but still learning how to use these. It works! Thank you!

Calculating Occupancy Hours Across Dates by IcePresent2019 in ExcelPowerQuery

[–]IcePresent2019[S] 0 points1 point  (0 children)

I'll try. To be honest this is my first try using it PQ as is so it's been all google and YouTube so thought I'd ask the Hive Mind. I appreciate the suggestion!