Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. List starters and leavers on separate sheet 2

      • myexcelstar
    2. Replies
      2
      Views
      368
      2
    3. myexcelstar

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

      • jumper5two
    2. Replies
      0
      Views
      250
    1. Excel: I want a list of dates to populate if the word fail is entered 4

      • jdwart
    2. Replies
      4
      Views
      489
      4
    3. jdwart

    1. Using wildcard in conditional formula not working 3

      • Billyrj
    2. Replies
      3
      Views
      717
      3
    3. royUK

    1. range 5

      • zohar
    2. Replies
      5
      Views
      558
      5
    3. royUK

    1. Search bar using FILTER formula 1

      • chester1993
    2. Replies
      1
      Views
      324
      1
    3. Fluff13

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

      • alz1
      • alz1
    2. Replies
      2
      Views
      304
      2
    3. alz1

    1. Formula for finding Retirement Age 3

      • marudhak
    2. Replies
      3
      Views
      495
      3
    3. marudhak

    1. Top 10 from list 5

      • jbanks
    2. Replies
      5
      Views
      696
      5
    3. royUK

    1. Formula for Conditional Formatting in Tables 1

      • Crazy Brit
    2. Replies
      1
      Views
      550
      1
    3. royUK

    1. WEEKNUM system 1 and 2 2

      • arabella
    2. Replies
      2
      Views
      1k
      2
    3. arabella

    1. Orders created in rolling 7 days period 9

      • cire_d
    2. Replies
      9
      Views
      681
      9
    3. royUK

    1. Sort and filter 3 columns 3

      • Sheepkin_Coat
    2. Replies
      3
      Views
      501
      3
    3. alansidman

    1. Round Time up 3

      • onexc
    2. Replies
      3
      Views
      474
      3
    3. Estevaoba

    1. Calculated Values on a Filtered Table 3

      • mrbuttons
    2. Replies
      3
      Views
      589
      3
    3. royUK

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

      • VWRSue
    2. Replies
      1
      Views
      525
      1
    3. vietnt.fov

    1. Separating cell info counting in a pivot table 4

      • Smudge.Smith
    2. Replies
      4
      Views
      451
      4
    3. alansidman

    1. Finding y-axis value

      • husnafezaahmad
    2. Replies
      0
      Views
      184
    1. Grouping Time into specific Criteria/Group 3

      • mrbuttons
    2. Replies
      3
      Views
      487
      3
    3. rory

    1. Vlook up 5

      • jpetraityte
    2. Replies
      5
      Views
      556
      5
    3. jpetraityte

Display Options