Hello,
I need to create a macro that will give me all combinations of the listed data in sets of N. So lets say N is 2 i want 1*2 then 1*3 and and so on. I have seen a lot of looked and have seen macros similar to what i need but cant figure out how to adjust them to work for me.
<tbody>
</tbody>
I need to create a macro that will give me all combinations of the listed data in sets of N. So lets say N is 2 i want 1*2 then 1*3 and and so on. I have seen a lot of looked and have seen macros similar to what i need but cant figure out how to adjust them to work for me.
A | B | C | |
1 | 1*2 | ||
2 | 1*3 | ||
3 | 1*0 | ||
0 | 2*3 | ||
2*0 | |||
3*0 | |||
<tbody>
</tbody>