Forum Discussion
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 ...
Hi Tom_Clean_Sweep_4187 ,
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.