Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

      • SansSuit
    2. Replies
      3
      Views
      1.7k
      3
    3. Fluff13

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

      • SansSuit
    2. Replies
      5
      Views
      259
      5
    3. Fluff13

    1. Add text to formula 2

      • idrees ms
    2. Replies
      2
      Views
      195
      2
    3. idrees ms

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

      • ruppk825
    2. Replies
      6
      Views
      2.4k
      6
    3. ruppk825

    1. Vlookup across multiple worksheets and list sheet names

      • onexc
    2. Replies
      0
      Views
      99
    1. Help Extracting Data From String 2

      • gjwilson1216
    2. Replies
      2
      Views
      219
      2
    3. gjwilson1216

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

      • Sleeplol
    2. Replies
      1
      Views
      177
      1
    3. GlennUK

    1. Using SUBTOTAL formula within an IF formula 2

      • davec0864
    2. Replies
      2
      Views
      199
      2
    3. GlennUK

    1. automatic static date 1

      • Pedro003
    2. Replies
      1
      Views
      233
      1
    3. GlennUK

    1. Count overlapping time periods with condition

      • Daphilo
    2. Replies
      0
      Views
      223
    1. Formula to apply conditional formatting to highlight specific cells based the cell to the left

      • CapG
      • CapG
    2. Replies
      0
      Views
      370
    1. Test to columns help please 4

      • Elso1959
    2. Replies
      4
      Views
      156
      4
    3. Estevaoba

    1. Wilcard for vlookup

      • Pedro003
    2. Replies
      0
      Views
      103
    1. Slow Procces

      • Pedro003
    2. Replies
      0
      Views
      71
    1. COUNTIFS Formula Not Counting "1/0/1900" Date 1

      • JAMIEPACHOMSKI
    2. Replies
      1
      Views
      172
      1
    3. Pecoflyer

    1. Calculating year to date sum based on category 1

      • John9411
    2. Replies
      1
      Views
      123
      1
    3. wk9128

    1. VlookUp Crawls 3

      • asdf_99
    2. Replies
      3
      Views
      194
      3
    3. wk9128

    1. Max value lookup 3

      • Raha
      • Raha
    2. Replies
      3
      Views
      341
      3
    3. wk9128

    1. AND statement using multiple VLOOKUP criteria 3

      • stilton
    2. Replies
      3
      Views
      236
      3
    3. Pecoflyer

Label

Display Options