I am working on a database to analyze lottery numbers!
I have inputted the daily numbers from the last several months. I want to look at how frequently specific numbers are selected. example: how many times in the last 450 days did the number 7 get selected? etc. I want to do this for all 43 possible numbers. Attached is the sheet I am working with.
Thanks
lottohist.xlsx
Last edited by tam232; 08-14-2012 at 11:10 PM.
am unable to upload your file (im on 2003 at the moment), but a cheap and nasty work-around for that would be to have a list of all your numbers in (say) column A, then in column B, use...
=countif(your-range,A1)
copy that down, making sure you absolute your range 1st
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Worked great thanks so much!
you'r welcome. If this answered your question, please take a moment to mark the tread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks