Forum Discussion
Solved
Calculating then sorting by Highest to Lowest Average for Case Data in Excel
Hi! I'm hoping someone may be able to assist with something I am trying to achieve in excel with regards to calculating the average case resolution time on case data for a set of customers, so I ...
=SORT(UNIQUE(HSTACK(A2:A17,B2:B17,MAP(A2:A17,B2:B17,LAMBDA(name,case,AVERAGEIFS(C2:C17,A2:A17,name,B2:B17,case))))),3,-1)
If you have Office 365 you can apply this formula.
jani96 I would consider a pivot table as demonstrated in the attached file.