i want to make all possible combination lets say of 5 digits for 5 numbers ( 1,2,3,4,5 )
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
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...
a1:a6 i have
i need a formula that will get every combination possible from the 6 numbers
012, 013, 014, 015, 023, 024, 025, 034, 035, 045, 123, 124, 125, 134, 135, 145, 234, 235, 245, 345
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 ?