Excel all possible combinations ... except some

[Laura2988]

I am looking to get all possible outcomes from columns A to P to be listed in cell Q. I will try to upload the excel document but the results should be displayed in the following format, with no spaces between: [TABLE="width: 1024"]
<tbody>[TR]
[TD="width: 64"]XLM0YTNN1NN1R1NNN0000A2[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64, align: right"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64, align: right"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

In addition, I would like it to exclude from the results combinations of cells D4, D5, D6, D7 when cell C2 is present.

Thanks,
Laura

 

[Laura2988]

Please ignore the two boxes- did some accidental cutting and pasting. Cant seem to find a way to upload the document but i have cut and pasted it here:


[TABLE="width: 1024"]
<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]XLM0[/TD]
[TD="width: 64"]Y[/TD]
[TD="width: 64"]T[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]1R[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]N[/TD]
[TD="width: 64"]N[/TD]
[TD="class: xl65, width: 64"]0[/TD]
[TD="class: xl66, width: 64"]00[/TD]
[TD="width: 64"]A2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]S[/TD]
[TD]E[/TD]
[TD]A[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]H[/TD]
[TD]1L[/TD]
[TD="align: right"]3[/TD]
[TD]B[/TD]
[TD]S[/TD]
[TD]P[/TD]
[TD]B[/TD]
[TD="class: xl66"]01[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B[/TD]
[TD]W[/TD]
[TD]D[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD]L[/TD]
[TD]RA[/TD]
[TD][/TD]
[TD][/TD]
[TD]T[/TD]
[TD][/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]LA[/TD]
[TD][/TD]
[TD][/TD]
[TD]U[/TD]
[TD][/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD]K[/TD]
[TD]H[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E[/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]V[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

please try and imagine the cells (A1,B1 etc.)

 

[sandy666]

Cant seem to find a way to upload the document

you can post a link to the shared excel file using OneDrive, GoogleDrive or any similar