Forum Discussion
Combining data when removing duplicates
Morning forum, I'm looking for some help with removing duplicates in excel, I'd like to know if there is a way to sum total particular fields of data as duplicates are removed? For example,...
As variant
=LET(
ref, INDEX(data,,1),
value, INDEX(data,,2),
u, UNIQUE(ref),
total, MMULT(SEQUENCE(,ROWS(data),1,0), --(ref=TRANSPOSE(u) )*value ),
IF({1,0}, u, TRANSPOSE(total)))