Can you do video for counting lottery winners in Excel for multiple drawings and another video for calculating the lottery payouts in excel for multiple drawings.
another amazing video, when I hit the mega or power ball ill send you a little something lol no but seriously I will. Im working on pick 3/4/ nj cash 5 and pick 6 all for New Jersey! Staring with easier ones. Trying to figure out how to some how load "Mirror" numbers but I will figure it out! thanks again and I think I heard how to do it with "equals Or". haha. thanks
Hi Richard, is the following possible within Excel? My lotto ticket has 15 rows of 6 numbers on it....I would like to see\check if any of those rows have been drawn before.....the past results have 1894 rows of the 6 winning numbers...i hope that makes sense Thanks in advance Cheers Kev 🇦🇺
Can you please make excel survey form, I know there is via google, but some employer does not like to use via google form due to security. Here is my example: each question with 5 answers, each answer has a number from 1 to 5, if person selects answer 1, it will compute behind the scene placing 1 in another sheet, the Q1 column and 1 in another cell, and with calculations like sum, median, mean or whatever. So when the survey with 50 questions are answered, we just open the invisible and protected sheet password to show all the answers ResponderID 12105, Q1 5, Q2, 4, Q3 1 and so forth. I made this project many years ago and I saved it in a floppy disk, but I lost it, I can't find yet, I don't remember how I did. I did use codes, check marks on little box next to answer 1, answer 2, etc. I wonder if I find the floppy disk, where I am going to retrieve the project if the computers nowadays don't have the floppy disk slit. Thank you for your help.
That's like using a hammer to screw in a nail. A better tool exists. You don't need to use Google Sheets and email for what I show in the Survey video. You can use Excel and still import the results into Access. Surveys: 599cd.com/Surveys
Can you do video for counting lottery winners in Excel for multiple drawings and another video for calculating the lottery payouts in excel for multiple drawings.
I think this helps somewhat answer my question from the first lottery video
Sweet
Do you do excel for pick 3s or 4s ?
another amazing video, when I hit the mega or power ball ill send you a little something lol no but seriously I will. Im working on pick 3/4/ nj cash 5 and pick 6 all for New Jersey! Staring with easier ones. Trying to figure out how to some how load "Mirror" numbers but I will figure it out! thanks again and I think I heard how to do it with "equals Or". haha. thanks
I'll be waiting for my cut. :)
What version of excel are you using, is this one included in the multi-pack Microsoft Office package?
Is it a stand alone excel spreadsheet?
Latest version. MS 365 Sub.
Hi Richard, is the following possible within Excel?
My lotto ticket has 15 rows of 6 numbers on it....I would like to see\check if any of those rows have been drawn before.....the past results have 1894 rows of the 6 winning numbers...i hope that makes sense
Thanks in advance
Cheers Kev 🇦🇺
Possible? Sure. Am I gonna do it? Probably not any time soon. LOL
@@599CD No worries, thanks for the reply......i did figure it out, using an 'IF''
Cheers Kev
How to count numbers in vba excel
Can you please make excel survey form, I know there is via google, but some employer does not like to use via google form due to security. Here is my example: each question with 5 answers, each answer has a number from 1 to 5, if person selects answer 1, it will compute behind the scene placing 1 in another sheet, the Q1 column and 1 in another cell, and with calculations like sum, median, mean or whatever. So when the survey with 50 questions are answered, we just open the invisible and protected sheet password to show all the answers ResponderID 12105, Q1 5, Q2, 4, Q3 1 and so forth. I made this project many years ago and I saved it in a floppy disk, but I lost it, I can't find yet, I don't remember how I did. I did use codes, check marks on little box next to answer 1, answer 2, etc. I wonder if I find the floppy disk, where I am going to retrieve the project if the computers nowadays don't have the floppy disk slit. Thank you for your help.
That's like using a hammer to screw in a nail. A better tool exists. You don't need to use Google Sheets and email for what I show in the Survey video. You can use Excel and still import the results into Access. Surveys: 599cd.com/Surveys