Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Collate data from last x days based on todays date 7

      • DezB
      • DezB
    2. Replies
      7
      Views
      236
      7
    3. Pecoflyer

    1. color rows with almost same amount which appear more than twice with CF 4

      • RAJESH SHAH
    2. Replies
      4
      Views
      691
      4
    3. AliGW

    1. IF Functions and tolerances. 1

      • Shezmo1
    2. Replies
      1
      Views
      59
      1
    3. gijsmo

    1. Gathering name of products which have a same discount percentage 6

      • Q2Be
      • Q2Be
    2. Replies
      6
      Views
      704
      6
    3. alansidman

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

      • CapG
      • CapG
    2. Replies
      1
      Views
      599
      1
    3. GlennUK

    1. Format a cell based on information in another worksheet

      • DSessions
    2. Replies
      0
      Views
      183
    1. Formula to calculate COGS value using different prices based on qty available in different locations 1

      • jpetraityte
    2. Replies
      1
      Views
      752
      1
    3. Pecoflyer

    1. index Match not producing proper results 9

      • Billyrj
    2. Replies
      9
      Views
      1.2k
      9
    3. Billyrj

    1. AND statement using multiple VLOOKUP criteria 3

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

    1. Max value lookup 3

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

    1. VlookUp Crawls 3

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

    1. Calculating year to date sum based on category 1

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

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

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

    1. Slow Procces

      • Pedro003
    2. Replies
      0
      Views
      69
    1. Wilcard for vlookup

      • Pedro003
    2. Replies
      0
      Views
      98
    1. Test to columns help please 4

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

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

      • CapG
      • CapG
    2. Replies
      0
      Views
      369
    1. Count overlapping time periods with condition

      • Daphilo
    2. Replies
      0
      Views
      223
    1. automatic static date 1

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

    1. Using SUBTOTAL formula within an IF formula 2

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

Label

Display Options