Closed Thread
Results 1 to 6 of 6

Finding the duplicate occurances and displaying their frequency in descending order

  1. #1
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Lightbulb Finding the duplicate occurances and displaying their frequency in descending order

    Hi,

    i have a set of data in excel as followes:

    A b
    16 12
    14 1
    5 3
    16 43
    1 14
    3 5
    5 3
    the desired solution that i am looking to get in c and d and e is as followes:
    C d e
    3 5 3
    14 1 2


    in the above example at the top there is 3 in c1 and 5 in d1 because it has occured 3 times in the data also their frequency if displayed in e1 as 3 because it has occured three times and c2 is 14 and d2 is 1 because it has occured 2 times also their frequency is displayed in e2 as 2 as it has occured 2 times in the data.

    I have also attached a workbook to receive some solutions , so hoping to receive genuine response from serious contributors.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,978

    Re: Finding the duplicate occurances and displaying their frequency in descending order

    Why have you posted this twice? You should not create duplicate threads (see Forum Rule #05 at the top of the screen).

    Pete

  3. #3
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Finding the duplicate occurances and displaying their frequency in descending order

    HI, Pete i havent posted this twice as you know the question and the desired solution both are different from previous posts

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,978

    Re: Finding the duplicate occurances and displaying their frequency in descending order

    What is this one, then:

    https://www.excelforum.com/excel-for...ml#post5460316

    if not a duplicate of this thread in a different sub-forum?

    Pete

  5. #5
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Finding the duplicate occurances and displaying their frequency in descending order

    solution is different and question is different as well

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,167

    Re: Finding the duplicate occurances and displaying their frequency in descending order

    Administrative Note:

    The opening posts in this and the other thread are identical.

    So, unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue in the original thread.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding the duplicate occurrences and displaying their frequency in descending order
    By LAVA2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2021, 03:58 PM
  2. Replies: 5
    Last Post: 11-12-2019, 10:58 AM
  3. [SOLVED] Finding and arranging rows then displaying their frequency in descending order:
    By LAVA2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2018, 05:44 AM
  4. [SOLVED] Finding only triple occurances of duplicate items
    By LAVA2 in forum Excel General
    Replies: 3
    Last Post: 04-30-2018, 05:42 AM
  5. Sorting in descending order and show duplicate values
    By cceze in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-19-2012, 09:33 AM
  6. count number of occurances in descending order
    By nazimscr in forum Excel General
    Replies: 2
    Last Post: 05-11-2011, 12:31 PM
  7. displaying data in descending order (automatically)
    By mrmiddleman in forum Excel General
    Replies: 5
    Last Post: 10-30-2007, 05:47 PM

Tags for this Thread

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