Davidprince
Programmer
Ladies and Gents
Another problem involving settling a bet. My friend has come up with a scheme for beating a roulette wheel (I tell him every 6 months or so he is mad, he still comes up with ideas!). Anyway, I had set up a spreadsheet where he could feed in the results (generally limited to 300 numbers) and formulae in the cells would let him check his theory much faster than doing it manually. I looked at it over the weekend and decided by filling the numbers from the spreadsheet to an array, I could produce the spreadsheet much more efficiently. That has now been completed, however he would still need to look through the spreadsheet and manually calculate if he wins or loses.
I noted Skip's comments on basic questions about arrays. I might be guilty of asking a basic question, if so please bear with me. I am using Excel 2007 and have got the easy part of the VBA program to work, as noted above.
In doing that preliminary work, I have created a one dimensional array containing 300 numbers (the number varies, but it would never be more than 400 numbers). I am wondering if using array formulae, I can check the array to see if a number has occurred 3 times in 9 for example.
Any advise appreciated.
Another problem involving settling a bet. My friend has come up with a scheme for beating a roulette wheel (I tell him every 6 months or so he is mad, he still comes up with ideas!). Anyway, I had set up a spreadsheet where he could feed in the results (generally limited to 300 numbers) and formulae in the cells would let him check his theory much faster than doing it manually. I looked at it over the weekend and decided by filling the numbers from the spreadsheet to an array, I could produce the spreadsheet much more efficiently. That has now been completed, however he would still need to look through the spreadsheet and manually calculate if he wins or loses.
I noted Skip's comments on basic questions about arrays. I might be guilty of asking a basic question, if so please bear with me. I am using Excel 2007 and have got the easy part of the VBA program to work, as noted above.
In doing that preliminary work, I have created a one dimensional array containing 300 numbers (the number varies, but it would never be more than 400 numbers). I am wondering if using array formulae, I can check the array to see if a number has occurred 3 times in 9 for example.
Any advise appreciated.