SOLVED

Average tenure of multiple employees

%3CLINGO-SUB%20id%3D%22lingo-sub-3431384%22%20slang%3D%22en-US%22%3EAverage%20tenure%20of%20multiple%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431384%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20tried%20to%20lookup%20but%20couldn't%20find%20anything.%20I%20am%20trying%20to%20take%20average%20of%20employees%20within%20organization%20however%2C%20there%20are%20certain%20employees%20who%20has%20worked%20in%20multiple%20jobs%20within%20organization%20and%20that%20it%20causing.%20I%20am%20attaching%20a%20sample%20dataset%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3431384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3431464%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20tenure%20of%20multiple%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783518%22%20target%3D%22_blank%22%3E%40Krishck%3C%2FA%3E%26nbsp%3BYou%20can%20use%20SUMIF%20to%20sum%20the%20tenures%20of%20each%20employee%20and%20then%20average%20it.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3431497%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20tenure%20of%20multiple%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431497%22%20slang%3D%22en-US%22%3EHi%20Riny_van_Eekelen%20Thank%20you%20for%20the%20response.%20That%20is%20what%20I%20am%20looking%20at.%3CBR%20%2F%3E%3CBR%20%2F%3EQuick%20question%3A%20As%20of%20now%2C%20we%20are%20in%202016%20not%20moved%20to%20365%2C%20any%20chances%20of%20achieving%20this%20in%202016%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3431504%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20tenure%20of%20multiple%20employees%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431504%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783518%22%20target%3D%22_blank%22%3E%40Krishck%3C%2FA%3E%26nbsp%3BJust%20create%20the%20list%20of%20unique%20employee%20names%20manually%20or%20use%20the%20formula%20added%20in%20column%20K%20in%20the%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

 

I did tried to lookup but couldn't find anything. I am trying to take average of employees within organization however, there are certain employees who has worked in multiple jobs within organization and that it causing. I am attaching a sample dataset

3 Replies

@Krishck You can use SUMIF to sum the tenures of each employee and then average it. See attached.

Hi Riny_van_Eekelen Thank you for the response. That is what I am looking at.

Quick question: As of now, we are in 2016 not moved to 365, any chances of achieving this in 2016?
best response confirmed by Krishck (Occasional Contributor)
Solution

@Krishck Just create the list of unique employee names manually or use the formula added in column K in the attached file.