Forum Discussion
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 column (see yellow cells in below figure as example).
Many thanks!
3 Replies
- 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???
