Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • khuramdon
    3. Replies
      8
      Views
      473
      8

    4. khuramdon

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

      • Jaffey
    3. Replies
      1
      Views
      205
      1

    4. Carim

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

      • khanaran
    3. Replies
      21
      Views
      1.9k
      21

    4. bosco_yip

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

      • Cor54321
    3. Replies
      7
      Views
      377
      7

    4. Carim

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

      • browncoat
    3. Replies
      1
      Views
      153
      1

    4. royUK

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

      • Dezine
    3. Replies
      5
      Views
      409
      5

    4. Carim

    2. 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
    3. Replies
      8
      Views
      338
      8

    4. Carim

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

      • sobi_256
    3. Replies
      8
      Views
      356
      8

    4. Carim

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

      • khuramdon
    3. Replies
      11
      Views
      689
      11

    4. Carim

    2. Formula sheet with multiple inputs and outputs 5

      • tacotoy99
    3. Replies
      5
      Views
      295
      5

    4. Carim

    2. Dropdown Menu & VLookup formula not working 9

      • Xani
      • Xani
    3. Replies
      9
      Views
      689
      9

    4. Xani

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

      • khanaran
    3. Replies
      5
      Views
      350
      5

    4. Carim

    2. Xlookup or Index/Match with two criteria 7

      • mljohn
    3. Replies
      7
      Views
      487
      7

    4. Carim

    2. If statement 10

      • waterscapes
    3. Replies
      10
      Views
      743
      10

    4. Carim

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

      • jodiegreen11
    3. Replies
      6
      Views
      817
      6

    4. Carim

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

      • Foday
    3. Replies
      14
      Views
      781
      14

    4. Carim

    2. Total value across multiple sheets 5

      • iqubal82
    3. Replies
      5
      Views
      382
      5

    4. iqubal82

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

      • onexc
    3. Replies
      7
      Views
      397
      7

    4. Carim

    2. Find common part number amongst various suppiers 1

      • mljohn
    3. Replies
      1
      Views
      237
      1

    4. alansidman

    2. INDEX MATCH across sheets 8

      • jbanks
    3. Replies
      8
      Views
      531
      8

    4. Carim

Display Options