Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Locate any consecutive cells in a row (where employee worked)

      • jumper5two
    3. Replies
      0
      Views
      384

    2. Excel: I want a list of dates to populate if the word fail is entered 4

      • jdwart
    3. Replies
      4
      Views
      765
      4

    4. jdwart

    2. range 5

      • zohar
    3. Replies
      5
      Views
      897
      5

    4. royUK

    2. Using wildcard in conditional formula not working 3

      • Billyrj
    3. Replies
      3
      Views
      923
      3

    4. royUK

    2. Search bar using FILTER formula 1

      • chester1993
    3. Replies
      1
      Views
      498
      1

    4. Fluff13

    2. Top 10 from list 5

      • jbanks
    3. Replies
      5
      Views
      965
      5

    4. royUK

    2. using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2

      • alz1
      • alz1
    3. Replies
      2
      Views
      436
      2

    4. alz1

    2. Formula for finding Retirement Age 3

      • marudhak
    3. Replies
      3
      Views
      753
      3

    4. marudhak

    2. Formula for Conditional Formatting in Tables 1

      • Crazy Brit
    3. Replies
      1
      Views
      785
      1

    4. royUK

    2. WEEKNUM system 1 and 2 2

      • arabella
    3. Replies
      2
      Views
      1.3k
      2

    4. arabella

    2. Round Time up 3

      • onexc
    3. Replies
      3
      Views
      695
      3

    4. Estevaoba

    2. Orders created in rolling 7 days period 9

      • cire_d
    3. Replies
      9
      Views
      1.2k
      9

    4. royUK

    2. Sort and filter 3 columns 3

      • Sheepkin_Coat
    3. Replies
      3
      Views
      687
      3

    4. alansidman

    2. Calculated Values on a Filtered Table 3

      • mrbuttons
    3. Replies
      3
      Views
      809
      3

    4. royUK

    2. Separating cell info counting in a pivot table 4

      • Smudge.Smith
    3. Replies
      4
      Views
      660
      4

    4. alansidman

    2. Providing Notification of When a Task is Due Based on Dates 1

      • VWRSue
    3. Replies
      1
      Views
      672
      1

    4. vietnt.fov

    2. Finding y-axis value

      • husnafezaahmad
    3. Replies
      0
      Views
      246

    2. Grouping Time into specific Criteria/Group 3

      • mrbuttons
    3. Replies
      3
      Views
      811
      3

    4. rory

    2. Blank cells replace zeros 30

      • CJamesUK
    3. Replies
      30
      Views
      3k
      30

    4. royUK

    2. Vlook up 5

      • jpetraityte
    3. Replies
      5
      Views
      914
      5

    4. jpetraityte

Label

Display Options