Hi all - Newbie here. I have a problem I hope you all can help me with. Have a column of data that I want to count the frequency on. i.e.:

Bob
Bob
Jim
Bob
Mary
Jim
Bob

I can run the Countif() function, which sorted will make it look like this:

Bob 4
Bob 3
Bob 2
Bob 1
Jim 2
Jim 1
Mary 1

Would like it to read:

Bob 4
Bob 4
Bob 4
Bob 4
Jim 2
Jim 2
Mary 1

Any Ideas?

SD