Hello friends,

If I have a column of unique numbers in a spreadsheet, is it possible to use excel to generate every single possible pairing of different numbers from that selection of numbers?

For example if the numbers were 1,2,3 and 4 could I get excel to generate two columns that were

1,2
1,3
1,4
2,1
2,3
2,4
3,1
3,2
3,4

Have a feeling that I haven't explained that very clearly but hope someone can help...

Thank you.