Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

      • jumper5two
    2. Replies
      0
      Views
      178
    1. List starters and leavers on separate sheet 2

      • myexcelstar
    2. Replies
      2
      Views
      239
      2
    3. myexcelstar

    1. Football form 5

      • gdouvl1984
    2. Replies
      5
      Views
      478
      5
    3. royUK

    1. Excel SUMIFS Formula dashboard 1

      • Amyhosh11
    2. Replies
      1
      Views
      181
      1
    3. royUK

    1. COUNTA, SUMIF and Concatenate 1

      • El Gallo
    2. Replies
      1
      Views
      259
      1
    3. El Gallo

    1. How to automatically apply this formula? 14

      • MazExpress
    2. Replies
      14
      Views
      665
      14
    3. royUK

    1. How to convert today (44083) into 09/09/2020 in the next column 7

      • ivanfromitaly
    2. Replies
      7
      Views
      425
      7
    3. royUK

    1. How do i find the row number from a formula 5

      • PeterMac2020
    2. Replies
      5
      Views
      404
      5
    3. royUK

    1. Add a calculated field to a pivot table 1

      • cobber1418
    2. Replies
      1
      Views
      218
      1
    3. alansidman

    1. Need Help with Resetting a Countif Function 6

      • BDGibson4
    2. Replies
      6
      Views
      462
      6
    3. royUK

    1. Vlookup formula for sum the values with filtering the data's month wise 7

      • elsuji
    2. Replies
      7
      Views
      361
      7
    3. elsuji

    1. CountIf Multiple Columns per Rows 9

      • mrbuttons
    2. Replies
      9
      Views
      608
      9
    3. royUK

    1. Vlookup formula with date conditions 3

      • GarethR
    2. Replies
      3
      Views
      359
      3
    3. bosco_yip

    1. Running count of occurrence in list using array formula with spill range 4

      • Range Rover
    2. Replies
      4
      Views
      601
      4
    3. Range Rover

    1. VBA Code Modification 11

      • Excel&VBA
    2. Replies
      11
      Views
      501
      11
    3. royUK

    1. Average and Median formula with conditions 4

      • dejamls
    2. Replies
      4
      Views
      498
      4
    3. dejamls

    1. Sum of a column and column total showing different results 3

      • alfadaz
    2. Replies
      3
      Views
      284
      3
    3. Fluff13

    1. Apostrophe Issue with Character Count 1

      • RSquirrel
    2. Replies
      1
      Views
      235
      1
    3. Fluff13

    1. Sum row from 1 worksheet if information matches data in column of another worksheet 3

      • EZBreathe-Sarah
    2. Replies
      3
      Views
      266
      3
    3. royUK

Display Options