Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Check Row for data in column and return value and heading for each column containing a value

      • Excel Noob
    3. Replies
      0
      Views
      70

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

      • RAJESH SHAH
    3. Replies
      6
      Views
      765
      6

    4. RAJESH SHAH

    2. starting a formula from the next cell on from the previous formula

      • DezB
      • DezB
    3. Replies
      0
      Views
      36

    2. IF Functions and tolerances. 3

      • Shezmo1
    3. Replies
      3
      Views
      103
      3

    4. gijsmo

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

      • DezB
    3. Replies
      7
      Views
      271
      7

    4. Pecoflyer

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

      • Q2Be
      • Q2Be
    3. Replies
      6
      Views
      711
      6

    4. alansidman

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

      • CapG
      • CapG
    3. Replies
      1
      Views
      607
      1

    4. GlennUK

    2. Format a cell based on information in another worksheet

      • DSessions
    3. Replies
      0
      Views
      185

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

      • jpetraityte
    3. Replies
      1
      Views
      754
      1

    4. Pecoflyer

    2. index Match not producing proper results 9

      • Billyrj
    3. Replies
      9
      Views
      1.2k
      9

    4. Billyrj

    2. AND statement using multiple VLOOKUP criteria 3

      • stilton
    3. Replies
      3
      Views
      236
      3

    4. Pecoflyer

    2. Max value lookup 3

      • Raha
      • Raha
    3. Replies
      3
      Views
      341
      3

    4. wk9128

    2. VlookUp Crawls 3

      • asdf_99
    3. Replies
      3
      Views
      197
      3

    4. wk9128

    2. Calculating year to date sum based on category 1

      • John9411
    3. Replies
      1
      Views
      124
      1

    4. wk9128

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

      • JAMIEPACHOMSKI
    3. Replies
      1
      Views
      172
      1

    4. Pecoflyer

    2. Slow Procces

      • Pedro003
    3. Replies
      0
      Views
      76

    2. Wilcard for vlookup

      • Pedro003
    3. Replies
      0
      Views
      104

    2. Test to columns help please 4

      • Elso1959
    3. Replies
      4
      Views
      159
      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
      371

    2. Count overlapping time periods with condition

      • Daphilo
    3. Replies
      0
      Views
      224

Label

Display Options