combination digits

Hello Everyone i want to make all possible combination lets say of 5 digits for 5 numbers ( 1,2,3,4,5 ) 11111,11112,11113 but i want to exclude certain outputs by limiting repetition of each char to 2 in a row like 11234 is acceptable but 11123 is not , as ( 1 ) is repeated 3 times can this...

Hi everyone. Just joined the forum and have been searching the past 3 days for an answer on how to make possible combinations out of a bunch of 2 pair numbers. Haven't used Excel in a very very long time so I'm basically a beginner. I extracted pairs of numbers from the three different tables...

my setup, in a1:a6 i have 0 1 2 3 4 5 i need a formula that will get every combination possible from the 6 numbers answers:20 values 012, 013, 014, 015, 023, 024, 025, 034, 035, 045, 123, 124, 125, 134, 135, 145, 234, 235, 245, 345 b1:b21

hi im conducting a stock count. Column A consists of a list of the barcodes I've scanned. in column A there is sometimes more than one of the same barcode when i have more than one of the same product. is there a way of deleting duplicate barcodes in column a and replace them with a 'Quantity'...

I want to create a list of every possibility of 8 digit numbers consisting of 0,1,2,3,4,5,6,7,8,9 There must have been 10^8 = 100,000,000 combinations if i am not wrong. Is it possible to create such list ?