Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. return a value based on multiple table references 2

      • dsmessenger
    2. Replies
      2
      Views
      211
      2
    3. dsmessenger

    1. Medain if formula not working 3

      • brin1980
    2. Replies
      3
      Views
      298
      3
    3. Fluff13

    1. Combining Text Data from multiple rows to one row 2

      • paulmcphillimy
    2. Replies
      2
      Views
      242
      2
    3. paulmcphillimy

    1. Automatically enter data into a cell based on another's cell value 2

      • VWRSue
    2. Replies
      2
      Views
      520
      2
    3. audreyvega

    1. Copy entire row to another sheet if value matches 10

      • passer_by
    2. Replies
      10
      Views
      572
      10
    3. royUK

    1. MOD(ROWS() Function 6

      • Garth Lean
    2. Replies
      6
      Views
      369
      6
    3. royUK

    1. Index match #REF! error 7

      • dsmessenger
    2. Replies
      7
      Views
      887
      7
    3. Fluff13

    1. Get Header data and row/column data value 4

      • IGACICI
    2. Replies
      4
      Views
      574
      4
    3. IGACICI

    1. AVERAGEIF a range of cells based on a specific value in adjacent cell but ignore empty cells? 6

      • browncoat
    2. Replies
      6
      Views
      510
      6
    3. browncoat

    1. How to get total days which it is Reported Date - Actual Finish? 2

      • Xani
      • Xani
    2. Replies
      2
      Views
      215
      2
    3. sobi_256

    1. Extract unique values based on multiple criteria 2

      • hafizt
    2. Replies
      2
      Views
      388
      2
    3. hafizt

    1. copy formula 2

      • guscy
    2. Replies
      2
      Views
      626
      2
    3. royUK

    1. Separate Letters and Numbers Formula 3

      • Gemma86
    2. Replies
      3
      Views
      243
      3
    3. Fluff13

    1. Formula Correction Required 4

      • ShoaibRajput1
    2. Replies
      4
      Views
      258
      4
    3. ShoaibRajput1

    1. Increment day count based on month (30/31 days) and incorporate leap years 4

      • leema
    2. Replies
      4
      Views
      319
      4
    3. royUK

    1. Auto Add/Subtract 10

      • JJeffery99
    2. Replies
      10
      Views
      580
      10
    3. yongle

    1. Excel macro 97 - rotate picture 4

      • cvhelios
    2. Replies
      4
      Views
      282
      4
    3. rory

    1. How to set prices over percentage

      • onexc
    2. Replies
      0
      Views
      160
    1. Hide used items in Data Validation dropdown list 4

      • Lukas1
    2. Replies
      4
      Views
      288
      4
    3. Lukas1

    1. Calculating minimum and maximum Price with different units 5

      • onexc
    2. Replies
      5
      Views
      419
      5
    3. royUK

Display Options