Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Vlookup using tabs with specific cell reference 2

      • wosborne
    2. Replies
      2
      Views
      797
      2
    3. wosborne

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

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

    1. inventory worksheet HELP! 6

      • ANoard92
    2. Replies
      6
      Views
      1.2k
      6
    3. royUK

    1. Color negative percentage red in a text string 5

      • crgannon
    2. Replies
      5
      Views
      1.2k
      5
    3. crushdrinker06

    1. Cell Reference and sorting 1

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

    1. extarct numbers with a pattern from alphanumeric string 3

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

    1. Generate cells with values from other cells 19

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

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

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

    1. Monthly Allocation 3

      • kapil.raj1985
    2. Replies
      3
      Views
      839
      3
    3. crushdrinker06

    1. Nested IF Statement Alternative 8

      • aussiformula
    2. Replies
      8
      Views
      1.5k
      8
    3. aussiformula

    1. Multiple Drop Downs dependent on the previous 1

      • rklafka
    2. Replies
      1
      Views
      606
      1
    3. crushdrinker06

    1. Countif or Array Formula 3

      • aussiformula
    2. Replies
      3
      Views
      1.2k
      3
    3. crushdrinker06

    1. Vlookup issues, if no is data found 1

      • jest3r
    2. Replies
      1
      Views
      907
      1
    3. AliGW

    1. Look for value based on multiple ranges 3

      • MagsinoAS
    2. Replies
      3
      Views
      838
      3
    3. pike

    1. adding dynamic range to get rid of blanks 1

      • chubbychub
    2. Replies
      1
      Views
      901
      1
    3. pike

    1. Excel changing part of the formula w/o logical cause 6

      • Michael AQ
    2. Replies
      6
      Views
      1.1k
      6
    3. Michael AQ

    1. If statement 2

      • aussiformula
    2. Replies
      2
      Views
      733
      2
    3. aussiformula

    1. Trying to create formula to exclude any cells that contain the word "D/C" 7

      • Anmari
    2. Replies
      7
      Views
      1.3k
      7
    3. Anmari

    1. Dynamic Named Ranges with Intermittent Blanks 3

      • dtp81390
    2. Replies
      3
      Views
      1.3k
      3
    3. royUK

    1. Sum of Calculation in single Cell 4

      • GIRISHBISHT
    2. Replies
      4
      Views
      1k
      4
    3. pike

Display Options