Generate Combinations

There are 4 different values A,B,C,D and seven columns (1-7). How to fill all possible combinations i.e. 7^4 I guess. e.g AAAAAAA,AAAAAAB ...

So there will be 2401 rows with all possible combinations

Thanks

So AAAAAAB is the same as BAAAAAA ?
because if not then you are not simply looking for combinations, and it will result in 16384 values.

If the position of the B in the above does matter, meaning AAAAAAB and AAAAABA are different, then this code ought to work:

Please Login or Register  to view this content.

Here's a non-VBA spreadsheet formula based solution that seems like it should work: https://www.excelforum.com/tips-and-...ml#post4640511

Happy to help