Link to home
Start Free TrialLog in
Avatar of spudmcc
spudmccFlag for United States of America

asked on

Count each unique value and give running total

Hi Experts

Need a bit of help on this issue please.

In column A, I have several thousand names of clients.  What I need to do is
to count each unique value and assign the running total in column B.  See example.  Column A is my original list and column B is what I need to create.

Column A                           Column B

John                                          1
John                                          2
Mary                                         1
Joe                                            1
Joe                                            2
Fred                                          1
John                                          3

Thanks so much in advance.

A
ASKER CERTIFIED SOLUTION
Avatar of John Easton
John Easton
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of spudmcc
spudmcc
Flag of United States of America image

ASKER

Thanks to you both so much for the quick response.  I was hoping it would be easy.  
You both came up with the same solution at almost the same time so I hope you are alright with me splitting the points.  

Thanks again

A