Creating an excel macro to sum lines with duplicate values
- by john
I need a macro to look at the list of data below, provide a number of instances it appears and sum the value of each of them. I know a pivot table or series of forumlas could work but i'm doing this for a coworker and it has to be a 'one click here' kinda deal. The data is as follows.
A B
Smith 200.00
Dean 100.00
Smith 100.00
Smith 50.00
Wilson 25.00
Dean 25.00
Barry 100.00
The end result would look like this
Smith 3 350.00
Dean 2 125.00
Wilson 1 25.00
Barry 1 100.00
Thanks in advance for any help you can offer!