Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. color rows with almost same amount which appear more than twice with CF 6

      • RAJESH SHAH
    3. Replies
      6
      Views
      996
      6

    4. RAJESH SHAH

    2. Format a cell based on information in another worksheet

      • DSessions
    3. Replies
      0
      Views
      266

    2. Color code bar chart data bars based on a y- axis criteria dynamically 1

      • CapG
      • CapG
    3. Replies
      1
      Views
      731
      1

    4. GlennUK

    2. Gathering name of products which have a same discount percentage 10

      • Q2Be
      • Q2Be
    3. Replies
      10
      Views
      1k
      10

    4. alansidman

    2. Formula to calculate COGS value using different prices based on qty available in different locations 1

      • jpetraityte
    3. Replies
      1
      Views
      948
      1

    4. Pecoflyer

    2. AND statement using multiple VLOOKUP criteria 3

      • stilton
    3. Replies
      3
      Views
      390
      3

    4. Pecoflyer

    2. Calculating year to date sum based on category 1

      • John9411
    3. Replies
      1
      Views
      237
      1

    4. wk9128

    2. COUNTIFS Formula Not Counting "1/0/1900" Date 1

      • JAMIEPACHOMSKI
    3. Replies
      1
      Views
      341
      1

    4. Pecoflyer

    2. Slow Procces

      • Pedro003
    3. Replies
      0
      Views
      177

    2. Wilcard for vlookup

      • Pedro003
    3. Replies
      0
      Views
      261

    2. VlookUp Crawls 3

      • asdf_99
    3. Replies
      3
      Views
      340
      3

    4. wk9128

    2. Test to columns help please 4

      • Elso1959
    3. Replies
      4
      Views
      296
      4

    4. Estevaoba

    2. Formula to apply conditional formatting to highlight specific cells based the cell to the left

      • CapG
      • CapG
    3. Replies
      0
      Views
      431

    2. Count overlapping time periods with condition

      • Daphilo
    3. Replies
      0
      Views
      346

    2. Using SUBTOTAL formula within an IF formula 2

      • davec0864
    3. Replies
      2
      Views
      365
      2

    4. GlennUK

    2. Help Extracting Data From String 2

      • gjwilson1216
    3. Replies
      2
      Views
      361
      2

    4. gjwilson1216

    2. Vlookup across multiple worksheets and list sheet names 1

      • onexc
    3. Replies
      1
      Views
      352
      1

    4. Carim

    2. Add text to formula 2

      • idrees ms
    3. Replies
      2
      Views
      306
      2

    4. idrees ms

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

      • Sleeplol
    3. Replies
      1
      Views
      290
      1

    4. GlennUK

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

      • SansSuit
    3. Replies
      5
      Views
      389
      5

    4. Fluff13

Label

Display Options