Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Return cell value from closed WB using variable file path[s] 1

      • Sleeplol
    3. Replies
      1
      Views
      256
      1

    4. GlennUK

    2. Identify weekend that has the max number of occurrences 5

      • SansSuit
    3. Replies
      5
      Views
      360
      5

    4. Fluff13

    2. Identify Row Number on Different Sheet to complete COUNTIF on (in single formula) 6

      • ruppk825
    3. Replies
      6
      Views
      2.6k
      6

    4. ruppk825

    2. Less clunky way of listing missing month/day combinations 3

      • SansSuit
    3. Replies
      3
      Views
      1.8k
      3

    4. Fluff13

    2. automatic static date 1

      • Pedro003
    3. Replies
      1
      Views
      303
      1

    4. GlennUK

    2. Finding close text matches from a list of values 1

      • Mowgli
    3. Replies
      1
      Views
      484
      1

    4. bosco_yip

    2. Resume automatic counting 2

      • Pedro003
    3. Replies
      2
      Views
      261
      2

    4. bosco_yip

    2. Return true if a cell contains any three or more consecutive letters 1

      • jpsaini
    3. Replies
      1
      Views
      398
      1

    4. rory

    2. Counting Help 2

      • lightguy101
    3. Replies
      2
      Views
      237
      2

    4. royUK

    2. Index formula while working with different workbooks

      • onexc
    3. Replies
      0
      Views
      190

    2. index Match not producing proper results 9

      • Billyrj
    3. Replies
      9
      Views
      1.5k
      9

    4. Billyrj

    2. excel formula to find quarter 3

      • dkool
    3. Replies
      3
      Views
      320
      3

    4. dkool

    2. Advanced filter 2

      • gulucete
    3. Replies
      2
      Views
      492
      2

    4. rory

    2. Extract data based on multiple dropdowns

      • cherrithota
    3. Replies
      0
      Views
      156

    2. Lowest 3 of last 7 6

      • hamptongolfer11
    3. Replies
      6
      Views
      468
      6

    4. hamptongolfer11

    2. Count formula based on a column heading 3

      • HarshaMunoo
    3. Replies
      3
      Views
      663
      3

    4. Pecoflyer

    2. Help with formula 6

      • hamptongolfer11
    3. Replies
      6
      Views
      462
      6

    4. hamptongolfer11

    2. Multiple returns with 2 criteria from another workbook 15

      • xsmurf
    3. Replies
      15
      Views
      1.1k
      15

    4. Carim

    2. Conditional formatting with 2 criteria of 2 columns. 2

      • mrbuttons
    3. Replies
      2
      Views
      193
      2

    4. Pecoflyer

    2. Accrual formula 9

      • KEW115
    3. Replies
      9
      Views
      465
      9

    4. KEW115

Label

Display Options