Creating an excel macro to sum lines with duplicate values

Posted by john on Stack Overflow See other posts from Stack Overflow or by john
Published on 2010-02-15T17:22:45Z Indexed on 2010/04/27 7:33 UTC
Read the original article Hit count: 436

Filed under:
|
|
|
|

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!

© Stack Overflow or respective owner

Related posts about excel

Related posts about macro