ExcelBanter - I have 2 items that are selectable in 36 ways; How do I sort 1 & 2

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I have 2 items that are selectable in 36 ways; How do I sort 1 & 2 (https://www.excelbanter.com/excel-worksheet-functions/186444-i-have-2-items-selectable-36-ways%3B-how-do-i-sort-1-2-a.html)

cwhisperer

I have 2 items that are selectable in 36 ways; How do I sort 1 & 2

I have done this before but it was a long time ago. e.g.
Apple Banana Apple Banana Apple Banana
Banana Apple Banana Apple Banana Apple
Banana Banana Banana Banana Banana Banana
Apple Apple Apple Apple Apple Apple
Apple Apple Banana Banana Apple Apple
Banana Banana Apple Apple Banana Banana
and so on up to 36 selections=6 rows of 6

All times are GMT +1. The time now is 03:30 PM.