|
In response to
"Run a pivot table and for each unique value in A, figure out how to divide the sum of E by the count of E. -- (edited)"
by
Super Daddy Princess
|
It actually worked! -- (edited)
Posted by
znufrii
Feb 7 '19, 17:27
|
=IF(VLOOKUP(A2,$G$2:$I$4,2)/VLOOKUP(A2,$G$2:$I$4,3)=E2,"","!")
Where $G$2:$I$4 is the location of a pivot table where the rows are the values from Column A, and the columns are the sum of Column E and the count of Column E.
|