Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

      • Jaffey
    2. Replies
      1
      Views
      205
      1
    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. How to automatically add new ranges to formulas in new rows? 7

      • Cor54321
    2. Replies
      7
      Views
      377
      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
      153
      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
      409
      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
      338
      8
    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. Need any formula or solution if 3 numbers match in a single cell 11

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

    1. Formula sheet with multiple inputs and outputs 5

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

    1. Dropdown Menu & VLookup formula not working 9

      • Xani
      • Xani
    2. Replies
      9
      Views
      689
      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
      350
      5
    3. Carim

    1. Xlookup or Index/Match with two criteria 7

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

    1. If statement 10

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

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

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

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

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

    1. Total value across multiple sheets 5

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

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

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

    1. Find common part number amongst various suppiers 1

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

    1. INDEX MATCH across sheets 8

      • jbanks
    2. Replies
      8
      Views
      531
      8
    3. Carim

Display Options