I would appreciate help how to solve this problem i have in Excel.
I would like to create 100 unique rows with 5 columns, where columns should contain unique numbers from a predefined list (1, 2, 3, 4, 5, 6, 7). Same number can only be used once in the row.
How can I do this with a formula? Will need to populate similar unique rows with fewer columns available as well at a lager stage so a generic approach would be appreciated.
Please see attached example image.
Hope this question make sense what I want to accomplish. Thanks in advance for your help!
/Chris
Aucun commentaire:
Enregistrer un commentaire