Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
hoovarted
Lv 7
hoovarted asked in Computers & InternetSoftware · 8 years ago

I have an Excel® question?

What formula do I use to find a common number within multiple cells of a large Excel® spreadsheet?

Update:

Yes, I am trying to find the number or numbers that are appearing the most. I will try this...

Thank you.

I am actually trying to determine the top 3 numbers?

2 Answers

Relevance
  • brayden
    Lv 7
    8 years ago
    Favorite Answer

    Are you asking for how to find the number that is appearing the most? If so use the MODE formula

    example:

    If I have numbers in cells A1 to Z1000 my formula would be

    =MODE(A1:Z1000)

  • IXL@XL
    Lv 7
    8 years ago

    Data in col A

    B2 =IF(A2=F$2,"",A2) copy across 1 column then down to match col A

    F2 =MODE(A:A) copy across to H2

    or you can use the sort/filter feature to display the top 3 numbers

Still have questions? Get your answers by asking now.