Forum Discussion

Tom_Clean_Sweep_4187's avatar
Tom_Clean_Sweep_4187
Copper Contributor
Apr 08, 2019

How to get an average of non-adjacent cells from one column based on data in another column

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?

1 Reply

Resources