Counting Frequency of duplicates for each unique value and corresponding data

**fredman** · 02-03-2009, 10:40 PM

Hey Everyone,

First, thanks so much for setting this forum up to whoever did this. I will try my best to explain things. I used to program in MySQL, but having some difficulties with something I think should be simple. Instead of trying to explain this I will put what I have and what I need it to out put.

So if I have a Column like so

Jack data data data
Fred
John
Steve
Jack data data data
Jack data data data
Fred
John

I would like it to output

3 Jack data data data
2 Fred
2 John
1 Steve

**Kieran** · 02-03-2009, 11:33 PM

Fredman,

You have cross-posted in teh excel questions forum.
Please refer to the other thread.

**fredman** · 02-03-2009, 11:42 PM

I thought I was in two separate forums. Sorry. I just wanted to try out two places and see which one was a better forum. I had to register for each one so I din't know they were the same! I really apologize. Can you help me out more in the other thread? I really appreciate it.

**shg** · 02-04-2009, 12:55 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!