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
Bookmarks