+ Reply to Thread
Results 1 to 4 of 4

Counting Frequency of duplicates for each unique value and corresponding data

  1. #1
    Registered User
    Join Date
    02-03-2009
    Location
    virginia
    MS-Off Ver
    Excel 2004 mac
    Posts
    6

    Counting Frequency of duplicates for each unique value and corresponding data

    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

  2. #2
    Forum Contributor Kieran's Avatar
    Join Date
    10-02-2003
    Location
    Perth, Western Australia
    MS-Off Ver
    Office 2003
    Posts
    109

    Re: Counting Frequency of duplicates for each unique value and corresponding data

    Fredman,

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

  3. #3
    Registered User
    Join Date
    02-03-2009
    Location
    virginia
    MS-Off Ver
    Excel 2004 mac
    Posts
    6

    Re: Counting Frequency of duplicates for each unique value and corresponding data

    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.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Counting Frequency of duplicates for each unique value and corresponding data

    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!
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1