Maximum Combination

[Excel_Pa]

Hi All,

How to arrive the maximum Record-combination available for the data explained in the excel sheet using excel function.
Ex:
HN#1 has H#1(Husband) & W#1 (Wife) as couple. They should stick as couple no change in that.
My Requirement:
·******** There are 24 houses available in a town. I want to know each combination of
o** Record#1: HN#1 with rest of houses says HN#2 to HN#24, like wise
o** Record#2: HN#2 with rest of houses says HN#3 to HN#24,
o** Record#3: HN#3 with rest of houses says HN#4 to HN#24…….
·******** Since HN#1 to HN#2 already exits as record, not require the vice versa combination i.e., HN#2 to HN#1.

Thanks in advance.

[Kaper]

First I thought that strightforward macro will do:

Please Login or Register  to view this content.

But after the test I realized that in your data there is no:
H#11 W#11 HN#11

and immediately after:
H#10 W#10 HN#10
appears:
H#12 W#12 HN#12

so I rewrote a bit the procedure. Of course you can add application.screenupdating = false at the beginning to make it quicker (if there is more than 23 couples). but for the test data it's quick enough.

Please Login or Register  to view this content.