Need Excel Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2783644%22%20slang%3D%22en-US%22%3ENeed%20Excel%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2783644%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%203%20years%20of%20HR%20data.%20I%20want%20to%20add%20a%20new%20column%20titled%20%22Labor%20Count%22%20which%20will%20have%20a%20formula%20that%20looks%20at%20the%20employee%20ID%20and%20month%20and%20enter%20in%20the%20decimal%20for%20the%20amount%20of%20times%20it%20appears%20to%20sum%20up%20to%201%20for%20that%20specific%20employee.%20I%20have%20a%20pivot%20table%20that%20is%20showning%20the%20count%20of%20records%20verses%20the%20distinct%20employee%20count.%20Can%20someone%20help%20with%20how%20I%20can%20write%20the%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2783644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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