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