Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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.

Can someone help me with Excel?

What I'd like to do is take a list of numbers and compare them to see which number repeats the most and place that number in another cell. Problem is, I don't know enough about Excel to write the proper formula. Can anyone help me?

Thanks

4 Answers

Relevance
  • isita
    Lv 5
    1 decade ago
    Favorite Answer

    =MODE(list of numbers here)

    e.g "=MODE(6,6,7,8,8,8,10)"

    OR if you need the mode of the numbers in the range A1-A13 then use "=MODE(A1:A13)"

  • Anonymous
    1 decade ago

    it's called mode....type that into the help engine in excel and follow the instructions...hope it helps....

  • mal
    Lv 7
    1 decade ago

    Maybe this site has the steps you are looking for http://www.excelexchange.com/

  • Anonymous
    1 decade ago

    no

Still have questions? Get your answers by asking now.