Solved

Count each unique value and give running total

Posted on 2013-09-27
Medium Priority
359 Views
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

A
0
Question by:spudmcc

LVL 11

Accepted Solution

John Easton earned 1000 total points
ID: 39527496
Assuming the data starts in cell A1 then type the below in cell B1 and drag or fill down:

``````=COUNTIF(A1:\$A\$1,A1)
``````
0

LVL 54

Assisted Solution

Rgonzo1971 earned 1000 total points
ID: 39527497
Hi,

pls try

=COUNTIF(A\$1:A1,A1)

Regards
0

Author Closing Comment

ID: 39527523
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
0

Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.