Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Dropdown Menu & VLookup formula not working 9

      • Xani
      • Xani
    2. Replies
      9
      Views
      1.2k
      9
    3. Xani

    1. Formula sheet with multiple inputs and outputs 5

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

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

      • khuramdon
    2. Replies
      11
      Views
      1.1k
      11
    3. Carim

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

      • sobi_256
    2. Replies
      8
      Views
      658
      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
      699
      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
      653
      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
      279
      1
    3. royUK

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

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

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

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

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

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

    1. Formula Required 3

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

    1. countif confusion 2

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

    1. Formula for picking every other cell? 5

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

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

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

    1. Calculate Duration in Hours from Date 5

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

    1. sum total invoice value on list line 3

      • sathishmadhav1
    2. Replies
      3
      Views
      537
      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
      698
      6
    3. alansidman

    1. Calculating a numeric score from a qualitative score 1

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

    1. index match using multiple spreadsheets return text YES OR NO 1

      • emthaolinh
    2. Replies
      1
      Views
      589
      1
    3. royUK

Label

Display Options