Forum Discussion

Brass Contributor

May 01, 2022

Solved

filtering and sum....

Hi, I have a column with over 1000 data text entries, where not all entries are unique. Is there a method to automatically filter the unique entries and SUM the corresponding cells in next colu...

excel

Formulas and Functions

office 365

OliverScheurich
May 01, 2022
drdree73
=LET(a,UNIQUE(B3:B17),b,SUMIF(B3:B17,a,C3:C17),CHOOSE({1,2},a,b))
Maybe with this formula.

OliverScheurich

Gold Contributor

May 01, 2022

drdree73

=LET(a,UNIQUE(B3:B17),b,SUMIF(B3:B17,a,C3:C17),CHOOSE({1,2},a,b))

Maybe with this formula.

drdree73
Brass Contributor
May 01, 2022
OliverScheurich , got it working! awesome! thank you!
- jpershke1510
  Copper Contributor
  Jun 28, 2022
  this is really the best way to do this? I want to do the same thing but with a LOT more elements so this equation is kind of cumbersome....it seems odd to me this isn't a common need and there isn't some way in excel to do this a lot easier???