Column A1:A7 contains "A" to "G"
Column C1:C7 contains "A" to "G"
Using the combin formula combin(14,2)=91

How to produce all the combinations in columns E row by row?

e.g. in E1=A,A
E2=A,B until E91=G,G

Can someone advise the formula.

Thank you for helping

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

there are not 91 combinations. There are 7 x 7 = 49 combinations.

In E1 put

=OFFSET($A$1,TRUNC((ROW()-1)/7),0)& ", " & OFFSET($C$1,MOD(ROW()-1,7),0)

then drag fill down.

--
Regards,
Tom Ogilvy

"Michael168" wrote in message
...

Column A1:A7 contains "A" to "G"
Column C1:C7 contains "A" to "G"
Using the combin formula combin(14,2)=91

How to produce all the combinations in columns E row by row?

e.g. in E1=A,A
E2=A,B until E91=G,G

Can someone advise the formula.

Thank you for helping.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/