+ 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
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    1,175

    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)

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