+ Reply to Thread
Results 1 to 3 of 3

Which 3 numbers comes up most often in a list.

  1. #1
    Registered User
    Join Date
    01-01-2020
    Location
    Virginia
    MS-Off Ver
    Excel 16.3
    Posts
    2

    Which 3 numbers comes up most often in a list.

    It’s been years since I’ve done anything with Excel so I’m sorry for such a simple question. I’ve attached a file and I know how to find out how many times a particular number comes up in a list of numbers using the COUNTIF command as demonstrated using 10 numbers, but what if my list were really long like 1,000 numbers using 100 different numbers? I really need to know which 3 numbers in the 100 came up the most often and which 3 numbers in the 100 came up the least often. What would be the easiest way to do this?

    Thanks in advance for any help you can provide!
    Tom
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Which 3 numbers comes up most often in a list.

    try these

    most common
    Please Login or Register  to view this content.
    least common
    Please Login or Register  to view this content.
    confirm with ctrl shift enter
    2nd most
    Please Login or Register  to view this content.
    confirm with ctrl shift enter
    3rd most
    Please Login or Register  to view this content.
    confirm with ctrl shift enter
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    01-01-2020
    Location
    Virginia
    MS-Off Ver
    Excel 16.3
    Posts
    2

    Re: Which 3 numbers comes up most often in a list.

    Scottiex,
    Thanks so much. I think this is exactly what I needed. I appreciate the quick reply. Have a great New Years!

+ 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. [SOLVED] To find all combinations of numbers from list of numbers that adds upto a specified number
    By Vivek2705 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2019, 06:33 AM
  2. Replies: 1
    Last Post: 03-07-2016, 01:58 PM
  3. list of numbers in excel and I need to find which numbers in the list add up to 16
    By mnmtnman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 12:25 PM
  4. Mean of Highest 20% of list of numbers when list of numbers may vary?
    By nufcac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2015, 07:29 AM
  5. Replies: 8
    Last Post: 11-19-2014, 06:12 PM
  6. [SOLVED] re-numbering a list of numbers based on another list of numbers to get a sequential order
    By ryan.wherry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-10-2014, 03:27 PM
  7. [SOLVED] Getting Excel 2007 to list the cell numbers of the top five ranked numbers in a column.
    By Securitysports in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2013, 11:42 AM

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