Hi

**Jol**,

jol said:

Having a bit of bother have excel 2000 at home and I am off work for a couple of weeks so can't get to my work PC. I tried the net answers to running a macro but to no avail.

__What Macro?__
The file I uploaded for you is purely a formula based SpreadSheet with

**NO** Macro's.

Perhaps you could post the Macro you are using for me to look at and see if I can adapt it to your needs please!

jol said:

Can I ask, what do you think about using historical data to select numbers. I am finding that because the rows contain past numbers you only find a portion of the numbers needed. Think of the data snaking its way down the rows, depending where you take your data from it only shows 3 or 4 numbers i.e first to middle column data or middle to top data unless your lucky.

Well, there is no easy answer to this.

If you don't use historical data to pick your numbers then there is no need to keep a SpreadSheet or any statistical analysis at all, or even the numbers that are drawn. You can then just pick your numbers by any method that you feel comfortable with!

In theory, using statistical analysis gives you a slight edge with respect to seeing trends of what has been, or what is to come.

I personally think that using filter parameters related to what the Minimum & Maximum limits for the entirety of the numbers drawn so far for example, less a reduction of whatever I class as well outside the norm is advantageous when choosing which numbers to play.

Although, as you well know, every combination has as much chance of being drawn as any other.

I hope this helps!

Regards,

PAB

-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-

12:45, restate my assumptions.

(1) Mathematics is the language of nature.

(2) Everything around us can be represented and understood through numbers.

(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.