Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Formula Required 3

      • foncesa62
    2. Replies
      3
      Views
      221
      3
    3. Carim

    1. Required a Formula to find out at least 3 times repeated values in a Single cell 8

      • khuramdon
    2. Replies
      8
      Views
      411
      8
    3. khuramdon

    1. Problem using Index/Match - how to handle duplicate amounts and dates 1

      • Jaffey
    2. Replies
      1
      Views
      181
      1
    3. Carim

    1. Formula to convert a gregorian date to a chinese date 21

      • khanaran
    2. Replies
      21
      Views
      1.4k
      21
    3. bosco_yip

    1. How to automatically add new ranges to formulas in new rows? 7

      • Cor54321
    2. Replies
      7
      Views
      312
      7
    3. Carim

    1. Erroneous #NAME? error that goes away when I drag the formula back over the cells showing the error 1

      • browncoat
    2. Replies
      1
      Views
      119
      1
    3. royUK

    1. Count the number of days in a date range that fall in a particular month 5

      • Dezine
    2. Replies
      5
      Views
      368
      5
    3. Carim

    1. Is it possible to have the user type a formula into a cell and have it treated as text so that other cells can incorporate that into their formula? 8

      • browncoat
    2. Replies
      8
      Views
      277
      8
    3. Carim

    1. sumifs work in one cell and shows 0 in other 8

      • sobi_256
    2. Replies
      8
      Views
      287
      8
    3. Carim

    1. Need any formula or solution if 3 numbers match in a single cell 11

      • khuramdon
    2. Replies
      11
      Views
      619
      11
    3. Carim

    1. Formula sheet with multiple inputs and outputs 5

      • tacotoy99
    2. Replies
      5
      Views
      256
      5
    3. Carim

    1. Dropdown Menu & VLookup formula not working 9

      • Xani
      • Xani
    2. Replies
      9
      Views
      603
      9
    3. Xani

    1. Split a name enter in a cell into separate cells , separated by firstname midname space surname 5

      • khanaran
    2. Replies
      5
      Views
      298
      5
    3. Carim

    1. Xlookup or Index/Match with two criteria 7

      • mljohn
    2. Replies
      7
      Views
      415
      7
    3. Carim

    1. If statement 10

      • waterscapes
    2. Replies
      10
      Views
      671
      10
    3. Carim

    1. Changing cells on separate sheets, working from a master 6

      • jodiegreen11
    2. Replies
      6
      Views
      771
      6
    3. Carim

    1. Freight Cost Calc. based on Transport and Toll Cost with some criteria 14

      • Foday
    2. Replies
      14
      Views
      681
      14
    3. Carim

    1. Total value across multiple sheets 5

      • iqubal82
    2. Replies
      5
      Views
      324
      5
    3. iqubal82

    1. How to use comma in a single worksheet to separate decimals. 7

      • onexc
    2. Replies
      7
      Views
      340
      7
    3. Carim

    1. Find common part number amongst various suppiers 1

      • mljohn
    2. Replies
      1
      Views
      206
      1
    3. alansidman

Display Options