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
2006-07-09 10:06:32 · 4 answers · asked by freetronics 5 in Computers & Internet ➔ Software
=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)"
2006-07-09 10:12:25 · answer #1 · answered by isita 5 · 3⤊ 0⤋
it's called mode....type that into the help engine in excel and follow the instructions...hope it helps....
2006-07-09 17:10:56 · answer #2 · answered by Anonymous · 1⤊ 0⤋
Maybe this site has the steps you are looking for http://www.excelexchange.com/
2006-07-09 17:12:32 · answer #3 · answered by mal 7 · 1⤊ 0⤋
no
2006-07-09 17:19:44 · answer #4 · answered by Anonymous · 0⤊ 1⤋