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…