This is the best I could come up with:

App St Main Des
House 1
01 01 01 01
02 22 18 14
03 19 11 23
04 16 24 04
House 2
05 05 05 05
06 02 22 18
07 23 15 03
08 20 04 08
House 3
09 09 09 09
10 06 02 22
11 03 19 07
12 24 08 12
House 4
13 13 13 13
14 10 06 02
15 07 23 11
16 04 12 16
House 5
17 17 17 17
18 14 10 06
19 11 03 15
20 08 16 20
House 6
21 21 21 21
22 18 14 10
23 15 07 19
24 12 20 24

There are six pairs who have two courses together, so I have arranged
for this to happen for the first and last courses - they are person
numbers 01/04, 05/08, 09/12, 13/16, 17/20 and 21/24.

Hope this helps.

Pete

On Feb 12, 8:44*am, Debbie wrote:
I have 24 couples taking part in a progressive dinner! 6 couples (houses)
serve aperitif, 6 starter, 6 main and 6 desert. with 4 couples eating at each
house including the host. The dilema is that no 2 couples can meet twice is
there a way of getting excel to work this out? I have numbered the *couples
1-24 then gone in blocks of 6 by 4, but each time I get some duplication????
Please help