I have a single rangle of numbers in Column A, and in Columns B and C and want to list all possible combinations of these numbers. If there is a possible solution without using a Macro I would perfer that, but if not I'll take what I can get.
Example Desired Output:
<TBODY>
</TBODY>
Example Desired Output:
Column A: | Column B: | Column C |
0001 | 0001 | 0001 |
0002 | 0001 | 0002 |
0003 | 0001 | 0003 |
0002 | 0001 | |
0002 | 0002 | |
0002 | 0003 | |
0003 | 0001 | |
0003 | 0002 | |
0003 | 0003 | |
<TBODY>
</TBODY>