+ Reply to Thread
Results 1 to 4 of 4

how to find most To most frequently occurring numbers in a column

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    new york, usa
    MS-Off Ver
    2007
    Posts
    8

    how to find most To most frequently occurring numbers in a column

    how to find find To list the most frequently occurring numbers in a column (i.e. most common, second most common, third most common, etc),

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,703

    Re: how to find most To most frequently occurring numbers in a column

    asking google about:
    most frequently occurring numbers in a column
    one gets the following, as topmost answer:
    https://exceljet.net/formula/most-fr...curring-number
    and then as third from the top:
    https://exceljet.net/formula/list-mo...curing-numbers
    And I think it is the one you are looking for.
    Best Regards,

    Kaper

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: how to find most To most frequently occurring numbers in a column

    To complement the information provided in 'post # 2', but for newer versions of Office, since 2010

    Use this formula and drag down to get the first, second, .... most frequently occurring numbers in a column

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,031

    Re: how to find most To most frequently occurring numbers in a column

    And just in case you want to return remaining counts of 1 --- in order to make those modal this trick from XOR LX applied to the 2nd formula Kaper cited.

    Array entered:
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    B
    C
    D
    E
    4
    Data
    Number
    count
    5
    93
    93
    3
    6
    92
    95
    2
    7
    93
    97
    2
    8
    94
    92
    1
    9
    95
    94
    1
    10
    96
    96
    1
    11
    97
    98
    1
    12
    98
    99
    1
    13
    99
    14
    93
    15
    97
    16
    95
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Most frequently occurring text
    By okat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-22-2017, 09:41 AM
  2. Finding Most Frequently Occurring Combinations
    By seanpalmgren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2015, 04:01 PM
  3. [SOLVED] Macro to Display the Top 5 Most Frequently Occurring Part Numbers
    By Hackboss007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2014, 03:15 PM
  4. Find most frequently occurring text string in in a VISIBLE range of cells
    By Odlanier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-01-2013, 05:27 PM
  5. Return most frequently occurring text in row
    By penfold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2011, 12:38 PM
  6. Most frequently occurring text
    By Deanomcbeano in forum Excel General
    Replies: 4
    Last Post: 08-12-2009, 08:58 AM
  7. most frequently occurring value
    By Pivotrend in forum Excel General
    Replies: 3
    Last Post: 12-23-2005, 08:10 AM

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