Apr 08 2019 12:04 PM - edited Apr 08 2019 12:40 PM
This is my first time posting and I hope I'm in the right area....
What I have is two columns of data for a given month. One column contains employees initials and the other contains the amount of time (in minutes) that it took them to perform a specific job. Is there a function available that would allow me to easily get the averages for each employee?
Here's a screen shot of what the columns look like:
I would prefer to keep the data in its original order (as sorting effects the dates that the data is assigned to) and would like something where under the column each employee's initials are listed next to their average during the period.
Is this something that can happen?
Apr 08 2019 01:31 PM
Not sure I catched all your requirements. As variant that could be PivotTable.
To keep sorting in order as initial appears it's better to create helper column with ID:s for initials, I took that pattern https://www.automateexcel.com/advanced-excel-skills/create-unique-identifiers/ for it. After that you pivot your data selecting Average for aggregating the time.