Need Excel Formula help

Copper Contributor

I have 3 years of HR data. I want to add a new column titled "Labor Count" which will have a formula that looks at the employee ID and month and enter in the decimal for the amount of times it appears to sum up to 1 for that specific employee. I have a pivot table that is showning the count of records verses the distinct employee count. Can someone help with how I can write the formula?

1 Reply
Hi

If you’re goal is to get a distinct count in the pivot table then a Power Pivot Table can do that. load your data to the Excel data model using power query and you then get a distinct count option in the field value options.


Otherwise do a =1/ COUNTIFS( colA, x, colB, y)

Wyn