The question is simple but the answer probably complicated. I have lots of data, but to be brief I gather everything in two columns. Column A, contains random names, and column B amounts. Based on the names on Column A, and need to have a SUM from the amounts but only distinct values, and only one SUM per name, not duplicate names.
Example:
So the solution should be:
John 70,000 Mike 60,000 Anna 50,000 Jennifer 40,000
pivot-table
, but did not ask about pivot tables. What does this have to do with them? Also, we need to know what you have already attempted to resolve this. We will help you from there.