combination digits

  1. E

    Help making combinations and calculate repeats.

    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...
  2. J

    all combinations of number

    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
  3. K

    Excel 2010. combining duplicates then deleting.

    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'...
  4. selant

    Every numeric possibility with 8 Digits

    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 ?

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top