ST Alpha - "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)" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 161

In response to "Excel help needed... I can't seem to find a good way to ask Google" by Dano

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)

Posted by Super Daddy Princess (aka znufrii) Feb 7 '19, 17:05

Then use VLOOKUP(?) inside of an IF statement to compare the result to each corresponding value in E.

No idea if this will actually work.

Responses:

It actually worked! -- (edited) - znufrii Feb 7, 17:27
(This assumes that E is numbers) -- nm - Super Daddy Princess Feb 7, 17:11

Post a message top