u/Normal-Touch-2396

▲ 77 r/travelphotos+1 crossposts

Hello everyone;

I've been making pivot tables for like 10 years for the dumbest quick sums ever.

last week i was messing around with a sales dump and accidentally typed GROUPBY instead of something else. had no idea this was even a thing.

so i have Region in A and Sales in C. i just did:

=GROUPBY(A2:A5000, C2:C5000, SUM)

and it just... spilled the whole summary. no insert pivot, no drag fields, no refresh. it just lives there.

i used to do this for a 30 second check. now it's one line

if you want it by region AND rep you can just hstack them:

=GROUPBY(HSTACK(A2:A5000,B2:B5000), C2:C5000, SUM)

pivotby does the same but with columns too. honestly i still use normal pivots for proper reports but for quick dirty checks this is so much better.

Anyone else just finding this now or am i late as usual?

Note; you need office 365.

▲ 56 r/sicily+1 crossposts