Formula to find requested number
Do you want to check how many times one specific number appears? Use:
CountIf(B2:F50,XX) where XX is the number you want to count.
If you want to check for all the numbers from 1 to 56, enter the following
formula into a cell in row 1 and drag that formula down to row 56.
CountIf($B$2:$F$50,Row())
HTH Otto
"Glockman" wrote in message
...
I want to find how many times a number 1 thru 56 shows up .
I have 5 columns of winning lotto numbers like below
Date col1 col2 col3 col4 col5
3/25/2009 2 5 24 51 52
Using Excel 2007
Thanks for any help
--
Larry W
|