May 25 2022 09:17 PM
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
May 25 2022 09:49 PM
@Krishck You can use SUMIF to sum the tenures of each employee and then average it. See attached.
May 25 2022 10:12 PM
May 25 2022 10:21 PM
Solution@Krishck Just create the list of unique employee names manually or use the formula added in column K in the attached file.
May 25 2022 10:21 PM
Solution@Krishck Just create the list of unique employee names manually or use the formula added in column K in the attached file.