Multi-Algorythm Super Excel formula

Reply #2

RJOh — Tue, 11 Dec 2007 22:51:01 GMT

I wrote a basic program that loads up a data file of past drawings and either use numbers from that file or allows me to enter up to 60 numbers. Then it create random combinations from the group of numbers and compare them with the data file and reject or accept them base on parameters I've entered. I usually reject combinations that have matched more than three in past drawings or combinations just picked.

I don't use or know Excel but I understand anything that can be done outside of Exce... [ More ]

Reply #1

time*treat — Tue, 11 Dec 2007 22:05:09 GMT

If you are asking if Excel can do this, yes.

As a static formula in a cell, I think it may be difficult, but I'm not a 'formula' expert.

As a macro that you run, yes.

Most of the limitations of Excel are found between the keyboard and the chair.

Multi-Algorythm Super Excel formula

Omniscient — Tue, 11 Dec 2007 21:40:42 GMT

Hi all,

Been trying to find out if you can combine multiple formulas in excel so that a few formulas are working together ..or is this a job for a more complex program ?

Say for example, I want to make a formula in Excel where I input ,,say 10 past numbers into it, then have a wheel perform its function, then have another formula run some filters, then a follow-up wheel kicks in and identifies a few key numbers from its wheel/pattern/filter formula. Can this be done ..and if not, in