Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Adding a range of cells based on addressing from a match 1

      • oddcarout
    2. Replies
      1
      Views
      440
      1
    3. skywriter

    1. vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9

      • Elusive
    2. Replies
      9
      Views
      1.5k
      9
    3. sktneer

    1. I am trying to do Countifs with multiple criteria and an array 2

      • pat1009
    2. Replies
      2
      Views
      695
      2
    3. pike

    1. Prevent Duplicate in Drop Down List 1

      • kapil.raj1985
    2. Replies
      1
      Views
      1.1k
      1
    3. pike

    1. Formula to update a cell date systematically 2

      • RNF
      • RNF
    2. Replies
      2
      Views
      533
      2
    3. sktneer

    1. Today() does not stay should lock,but change when open the next day 4

      • rooky1
    2. Replies
      4
      Views
      628
      4
    3. rooky1

    1. Trying to pull specific data from sheet1 to other sheets if it meets criteria 10

      • blade671
    2. Replies
      10
      Views
      1.4k
      10
    3. blade671

    1. Generate cells with values from other cells 19

      • DataWarrior
    2. Replies
      19
      Views
      2.2k
      19
    3. DataWarrior

    1. Taken taken minus breaks over midnight 4

      • Static Cat
    2. Replies
      4
      Views
      1k
      4
    3. Batman

    1. Multiplying a number betwee ranges in an IF statement 1

      • MichelleY16
    2. Replies
      1
      Views
      567
      1
    3. NBVC

    1. Return Specific Value from adjacent cell if values match 5

      • JadeRae
    2. Replies
      5
      Views
      1.9k
      5
    3. skywriter

    1. I keep getting #Name? for the answer to the cell. 3

      • blade671
    2. Replies
      3
      Views
      617
      3
    3. norie

    1. Calculate total hours worked on an oddly organized timesheet 4

      • APreston
    2. Replies
      4
      Views
      1.1k
      4
    3. APreston

    1. IF statement uisng index match 3

      • makp
    2. Replies
      3
      Views
      622
      3
    3. NBVC

    1. Vlookup using tabs with specific cell reference 2

      • wosborne
    2. Replies
      2
      Views
      690
      2
    3. wosborne

    1. inventory worksheet HELP! 6

      • ANoard92
    2. Replies
      6
      Views
      929
      6
    3. royUK

    1. Cell Reference and sorting 1

      • dtp81390
    2. Replies
      1
      Views
      489
      1
    3. crushdrinker06

    1. extarct numbers with a pattern from alphanumeric string 3

      • kaav06
    2. Replies
      3
      Views
      1k
      3
    3. crushdrinker06

    1. Color negative percentage red in a text string 5

      • crgannon
    2. Replies
      5
      Views
      976
      5
    3. crushdrinker06

    1. Petty Cash Template - Keep cell blank until data entered 3

      • Chaffrin
    2. Replies
      3
      Views
      1.6k
      3
    3. royUK

Display Options