mardi 22 février 2022

Create unique rows in Excel with limited data to be used in multiple columns

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

example




Aucun commentaire:

Enregistrer un commentaire