Expert: ronny fisher - 9/7/2009

Question
Hi,

Do you happen to know if there is a excel program that I can use to tell me what numbers come up the most?  At work, i have to enter in 6 numbers into a excel spreadsheet.  I then have to determine which numbers come up the most.  I enter in numbers between 1 and 70 each day.  I need to be able to create an excel program that will simply tell me which numbers come of the most.

Answer
chris -

this is a somewhat outside my area of expertise.
but for what it is worth, there is a (statistical)
excel function named COUNT. you might be able to
write a script that calls it for each of the numbers
1 thru 70 and thus obtain the frequencies of the
various numbers in your list. getting the maximum
frequency is then pretty easy. (you could just sort
the outcomes by frequency, for example.)

please don't ask me about writing scripts for excel;
that is not my thing.

ronny