Hi All,
I would like to find out a formula for the following situation, i have the following 5 integers lets say A, B, C, D, E (they can be numbers in between 0 to 4 & one number can repeat in the sequence like 01202 here 2 and 0 is repeating ) , i would like to see all the possible combinations for example ( as example stated 01202 would want to see all combinations possible such as 00122, 22001,12020 so on ... ). so is there any formula in excel where I can give the numbers and it can provide me with all possible combinations, thanks for the help
I would like to find out a formula for the following situation, i have the following 5 integers lets say A, B, C, D, E (they can be numbers in between 0 to 4 & one number can repeat in the sequence like 01202 here 2 and 0 is repeating ) , i would like to see all the possible combinations for example ( as example stated 01202 would want to see all combinations possible such as 00122, 22001,12020 so on ... ). so is there any formula in excel where I can give the numbers and it can provide me with all possible combinations, thanks for the help