Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Using wildcard in conditional formula not working 3

      • Billyrj
    3. Replies
      3
      Views
      473
      3

    4. royUK

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

      • jdwart
    3. Replies
      4
      Views
      125
      4

    4. jdwart

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

      • jumper5two
    3. Replies
      0
      Views
      122

    2. List starters and leavers on separate sheet 2

      • myexcelstar
    3. Replies
      2
      Views
      110
      2

    4. myexcelstar

    2. Football form 5

      • gdouvl1984
    3. Replies
      5
      Views
      235
      5

    4. royUK

    2. Excel SUMIFS Formula dashboard 1

      • Amyhosh11
    3. Replies
      1
      Views
      97
      1

    4. royUK

    2. COUNTA, SUMIF and Concatenate 1

      • El Gallo
    3. Replies
      1
      Views
      162
      1

    4. El Gallo

    2. How to automatically apply this formula? 14

      • MazExpress
    3. Replies
      14
      Views
      338
      14

    4. royUK

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

      • ivanfromitaly
    3. Replies
      7
      Views
      201
      7

    4. royUK

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

      • PeterMac2020
    3. Replies
      5
      Views
      235
      5

    4. royUK

    2. Add a calculated field to a pivot table 1

      • cobber1418
    3. Replies
      1
      Views
      119
      1

    4. AlanSidman

    2. Need Help with Resetting a Countif Function 6

      • BDGibson4
    3. Replies
      6
      Views
      270
      6

    4. royUK

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

      • elsuji
    3. Replies
      7
      Views
      177
      7

    4. elsuji

    2. CountIf Multiple Columns per Rows 9

      • mrbuttons
    3. Replies
      9
      Views
      343
      9

    4. royUK

    2. Vlookup formula with date conditions 3

      • GarethR
    3. Replies
      3
      Views
      198
      3

    4. bosco_yip

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

      • Range Rover
    3. Replies
      4
      Views
      277
      4

    4. Range Rover

    2. VBA Code Modification 11

      • LearnExcel&VBA
    3. Replies
      11
      Views
      273
      11

    4. royUK

    2. Average and Median formula with conditions 4

      • dejamls
    3. Replies
      4
      Views
      317
      4

    4. dejamls

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

      • alfadaz
    3. Replies
      3
      Views
      174
      3

    4. Fluff13

    2. Apostrophe Issue with Character Count 1

      • RSquirrel
    3. Replies
      1
      Views
      147
      1

    4. Fluff13

Display Options