Forum Discussion
Solved
Average tenure of multiple employees
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
Krishck Just create the list of unique employee names manually or use the formula added in column K in the attached file.
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?Krishck Just create the list of unique employee names manually or use the formula added in column K in the attached file.
