Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

    1. Dropdown Menu & VLookup formula not working 9

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

    1. Formula sheet with multiple inputs and outputs 5

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

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

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

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

      • sobi_256
    2. Replies
      8
      Views
      356
      8
    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
      340
      8
    3. Carim

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

      • Dezine
    2. Replies
      5
      Views
      409
      5
    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
      153
      1
    3. royUK

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

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

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

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

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

      • Jaffey
    2. Replies
      1
      Views
      205
      1
    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
      474
      8
    3. khuramdon

    1. Formula Required 3

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

    1. countif confusion 2

      • Boxxcar
    2. Replies
      2
      Views
      207
      2
    3. rory

    1. Formula for picking every other cell? 5

      • PuntingJawa
    2. Replies
      5
      Views
      393
      5
    3. PuntingJawa

    1. How to calculate totals on 1st of each month 3

      • slaphead007
    2. Replies
      3
      Views
      287
      3
    3. royUK

    1. Calculate Duration in Hours from Date 5

      • KayPee22
    2. Replies
      5
      Views
      364
      5
    3. royUK

    1. sum total invoice value on list line 3

      • sathishmadhav1
    2. Replies
      3
      Views
      275
      3
    3. Fluff13

    1. Help Inverting a table - list of requirements with associated tests to become a list of tests with associated requirements 6

      • UpToSpeed
    2. Replies
      6
      Views
      376
      6
    3. alansidman

    1. Calculating a numeric score from a qualitative score 1

      • la_coyote
    2. Replies
      1
      Views
      257
      1
    3. bosco_yip

Display Options