Thread: Loop & Count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Loop & Count

I am not sure I understand the rules.

From your description, it sounds like you need to loop throught the data,
row at a time.

For each row, generate every combination of two values from 6 and put them
in the dictionary
when done, count the items in the dictionary.

every combination of two has to be an subset of a combination of 3.

Tell me where I don't understand the rules.

--
Regards,
Tom Ogilvy

"Paul Black" wrote in message
...
Thanks for the Reply Tom,

Would you be Able to Assist me in Adapting the Code I Posted to
Calculate the 2 if 3 Scenario Please. I Assume ( Probably Wrongly ) that
it will Mean Adding a If...Then Statement or Such like to Count and Hold
the Total.
Thanks Very Much in Advance.

All the Best.
Paul


*** Sent via Developersdex http://www.developersdex.com ***