Actually, upon reflection, you would need to only check 22*21*20*19*18
*1500/5!, or 39 Million calculations, more doable... but still a long
calculation.

Bernie


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
It is possible, but you would need to check 80*79*78*77*76 different
combinations of 5 numbers against 300 groups, for a total of 4.3 TRILLION
comparisons. It would be very easy to program, but take a verrrrrrry long
to execute - well, unless you have access to a really fast computer.
Cutting down the number of groups, the combination length, or the highest
allowable number would decrease the calculation time, to the point were
you might be able to do it.

HTH,
Bernie
MS Excel MVP


"alikirca20" wrote in message
...

I have 300 number groups and each group has 22 different numbers (from 1
to 80).

I want to find 5 (or more) numbers that occur together the most.
Can I find these numbers by excel, macro, VBA or any program?

for example, let us suppose that 4-15-23-36-45 are the most common
numbers and these numbers are in 8 groups from 300.

Is it possible , I added my file to explain my question in detail,
Thanks


+-------------------------------------------------------------------+
|Filename: find common numbers1.zip |
|Download:
http://www.officefrustration.com/attachment.php?attachmentid=822|
+-------------------------------------------------------------------+



--
alikirca20