Formula Help

Reply #7

LottoFan — Thu, 13 May 2004 18:05:24 GMT

Quote: Originally posted by hypersoniq on May 10, 2004click here https://www.lotterypost.com/thread/85174.htmThat's the original thread with the copy-n-paste VBA macro for excel...hypersoniq: Thank you! Your VBA macro worked like a charm. I have also modified the code to produce all combinations for powerball (5 balls), arizona pick 6, and the california lottery. LottoFan

Reply #6

hypersoniq — Mon, 10 May 2004 08:13:47 GMT

click here https://www.lotterypost.com/thread/85174.htmThat's the original thread with the copy-n-paste VBA macro for excel...

Reply #5

Colin F — Sun, 09 May 2004 22:32:48 GMT

LottoFanI'm a RDBMS man using Access; flat file systems such as Excel are a bit too restrictive for me. My policy is not to intrude into other's area of expertise so I probably should have shutup. I know that Excel is very popular with members of this Forum.I remember distinctly seeing a solution for Excel because I looked at it and mentally noted that the solutions in Access were neater either doing it programatically or by cartesian joins.There's no point in me giving you the Access solutions... [ More ]

Reply #4

keystonechas — Sun, 09 May 2004 20:42:08 GMT

Send him a private message. I'm sure he'll be glad to help.Chas

Reply #3

LottoFan — Sun, 09 May 2004 20:17:53 GMT

Quote: Originally posted by Colin F on May 07, 2004LottoFanDo a search in this Forum. I think Hypersonic has posted a solution in Excell at least once if not twice.ColinOkay Colin, I searched all of hypersoniq's posts. Call me a dumba$$, but I couldn't find the formula. If you know where they are, would sure appreciate reposting them here. Thanks.

Reply #2

Colin F — Fri, 07 May 2004 04:51:31 GMT

LottoFanDo a search in this Forum. I think Hypersonic has posted a solution in Excell at least once if not twice.Colin

Reply #1

johnph77 — Fri, 07 May 2004 02:30:18 GMT

You'd have to go to a VB macro for this, but it can be done.....

Formula Help

LottoFan — Thu, 06 May 2004 22:32:08 GMT

I am working on a graphics program involving small lotteries. I will be using Excel to store the numbers. Does anyone know if there is a formula to print out a range of lottery numbers (or even all numbers) that can be used with Excel? Just so I am clrealy understood, I am not interested in printing out the winning numbers but ALL possible numbers. Thanks.