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
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.
Bookmarks