View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_5_] Peter T[_5_] is offline
external usenet poster
 
Posts: 84
Default List all combinations of 6/36 with unique 4 numbers


"joeu2004" wrote in message
...

If you are intereted, see "peterT combo.xls" at
https://www.box.com/s/409aee79b7b3949970f1. See the explanation in the
worksheet "README FIRST".


I couldn't find a README FIRST, but no worries, as I've already posted there
was a single letter typo in my code, it now produces same results as yours
(and in same order).

There really is no need for me to try to identify the flaw(s) in your
implementation. I had already pointed to my implementation, which seems
to truly work (and it is m-u-c-h faster). It produces 2240 combinations
with unique quad subsets.


Just to recap, as I mentioned I knocked something up very quickly just to
get a feel, not even sure I understood the objective yet alone if mine was
correct. You asked me to post it which I did. You didn't appear to be
entirely confirdent about yours either at the time.

Anyway, indeed yours is indeed very much faster, and very elegant too.
Actally the main aspects of both out codes are very similar (albeit not at
first glance). However but my filter approach is, not wrong but, poorly
conceived. Maybe a fresh look would have brought that in line with yours
too.

regards,
Peter T