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
      178

    2. List starters and leavers on separate sheet 2

      • myexcelstar
    3. Replies
      2
      Views
      232
      2

    4. myexcelstar

    2. Excel SUMIFS Formula dashboard 1

      • Amyhosh11
    3. Replies
      1
      Views
      181
      1

    4. royUK

    2. COUNTA, SUMIF and Concatenate 1

      • El Gallo
    3. Replies
      1
      Views
      259
      1

    4. El Gallo

    2. Football form 5

      • gdouvl1984
    3. Replies
      5
      Views
      478
      5

    4. royUK

    2. How to automatically apply this formula? 14

      • MazExpress
    3. Replies
      14
      Views
      665
      14

    4. royUK

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

      • ivanfromitaly
    3. Replies
      7
      Views
      425
      7

    4. royUK

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

      • PeterMac2020
    3. Replies
      5
      Views
      404
      5

    4. royUK

    2. Add a calculated field to a pivot table 1

      • cobber1418
    3. Replies
      1
      Views
      218
      1

    4. alansidman

    2. Need Help with Resetting a Countif Function 6

      • BDGibson4
    3. Replies
      6
      Views
      462
      6

    4. royUK

    2. CountIf Multiple Columns per Rows 9

      • mrbuttons
    3. Replies
      9
      Views
      608
      9

    4. royUK

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

      • elsuji
    3. Replies
      7
      Views
      360
      7

    4. elsuji

    2. Vlookup formula with date conditions 3

      • GarethR
    3. Replies
      3
      Views
      359
      3

    4. bosco_yip

    2. VBA Code Modification 11

      • Excel&VBA
    3. Replies
      11
      Views
      501
      11

    4. royUK

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

      • Range Rover
    3. Replies
      4
      Views
      601
      4

    4. Range Rover

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

      • alfadaz
    3. Replies
      3
      Views
      283
      3

    4. Fluff13

    2. Average and Median formula with conditions 4

      • dejamls
    3. Replies
      4
      Views
      497
      4

    4. dejamls

    2. Apostrophe Issue with Character Count 1

      • RSquirrel
    3. Replies
      1
      Views
      235
      1

    4. Fluff13

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

      • EZBreathe-Sarah
    3. Replies
      3
      Views
      266
      3

    4. royUK

    2. Show maximum value with condition 9

      • matyldk
    3. Replies
      9
      Views
      443
      9

    4. royUK

Display Options