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,...
Another approach using GROUPBY() and trimrange feature referencing full column.
=GROUPBY(DROP(B.:.B,1),DROP(C.:.C,1),SUM,,0)
=GROUPBY(B2.:.B12,C2.:.C12,SUM,,0)