Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Count values on a row that are within, equal to or greater than a value in row within the same column 2

      • Shezmo1
    3. Replies
      2
      Views
      446
      2

    4. Carim

    2. Pivot Table with a filter that displays a SUM of Total with a specific number or numbers 11

      • PETRODATAjames
    3. Replies
      11
      Views
      711
      11

    4. Carim

    2. SUMIFS or SUMPRODUCT both returning #VALUE error 2

      • DezB
      • DezB
    3. Replies
      2
      Views
      117
      2

    4. Carim

    2. Conditional Formatting to highlight column based on date in row 5

      • DezB
      • DezB
    3. Replies
      5
      Views
      217
      5

    4. Carim

    2. How to create Conditional Formatting with a range of dates? 4

      • GradB
    3. Replies
      4
      Views
      157
      4

    4. Carim

    2. Find matching string and get string of data in offset cell from raw dataset 15

      • robystar
    3. Replies
      15
      Views
      718
      15

    4. Carim

    2. INDEX/MATCH Formula - beyond me 11

      • DezB
      • DezB
    3. Replies
      11
      Views
      173
      11

    4. Carim

    2. Formula with cap 10

      • DANGPS
    3. Replies
      10
      Views
      317
      10

    4. DANGPS

    2. How to identify leaders? 9

      • GradB
    3. Replies
      9
      Views
      408
      9

    4. Carim

    2. Calculate the date between to cells 4

      • PETRODATAjames
    3. Replies
      4
      Views
      570
      4

    4. Carim

    2. Hourly Payroll Template 9

      • PETRODATAjames
    3. Replies
      9
      Views
      518
      9

    4. Carim

    2. Date in Excel if it is a Working Day 3

      • skamat
    3. Replies
      3
      Views
      167
      3

    4. Carim

    2. Predefined text in a cell 4

      • Allround_IT_er
    3. Replies
      4
      Views
      208
      4

    4. Carim

    2. Payroll worksheet with VLOOKUP issues 18

      • PETRODATAjames
    3. Replies
      18
      Views
      451
      18

    4. Carim

    2. Adding one more variable to an IF statement Formula 6

      • SkateRockandRoll
    3. Replies
      6
      Views
      309
      6

    4. Carim

    2. NPER with daily compounding interest? 6

      • jronaldlee
    3. Replies
      6
      Views
      237
      6

    4. Carim

    2. Copy rows from one sheet to another based on match 12

      • Smudge.Smith
    3. Replies
      12
      Views
      527
      12

    4. Carim

    2. Calculating a level 2

      • Kyp
      • Kyp
    3. Replies
      2
      Views
      224
      2

    4. Carim

    2. Need help to correct the error in the formula 2

      • RAJESH SHAH
    3. Replies
      2
      Views
      104
      2

    4. RAJESH SHAH

    2. Select Odd Rows from Named Range 21

      • Cobstillaware
    3. Replies
      21
      Views
      1.9k
      21

    4. Carim

Label

Display Options