Hi all,
I have a two column worksheet, ColumnA is a list of names and ColumnB is a list of numbers.
Example: (formatting in HTML is a little screwy but...)
A B
Derrek 10
Frank 8
Jane 20
Derrek 50
Sue 30
Sue 30
Tom 20
Emily 15
Derrek 14
The list is extremely long, and has multiples of the same name. I would like to get a total for ColumnB, but only count the highest number when there are duplicates.
So in this example, the total should end up being: 143.
The problem I am encountering is that when I remove duplicates, it is only removing Sue's 30 since both ColumnA and ColumnB are the same. It does not remove Derrek's 14 or Derrek's 10 since ColumnB is not a duplicate number.
Is there a function or even a multi-step process I can use to solve this issue?
Thanks in advance!
Drew
Bookmarks