Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Run time error 13 Type mismatch in VBA 1

      • analystbank
    2. Replies
      1
      Views
      568
      1
    3. analystbank

    1. Formula to show which Staff have had no sick leave for previous 3 months 6

      • skeeeter
    2. Replies
      6
      Views
      852
      6
    3. AliGW

    1. Count number of zeros that are within a range of consecutive zeros 2

      • annasigler
    2. Replies
      2
      Views
      1.2k
      2
    3. richadj4

    1. Complex IF (AND (OR formula 8

      • missjoy
    2. Replies
      8
      Views
      1.3k
      8
    3. KjBox

    1. Formula looking at 3 values 5

      • enhydra
    2. Replies
      5
      Views
      664
      5
    3. KjBox

    1. Count cells based on different criteria? 1

      • hkaur08
    2. Replies
      1
      Views
      496
      1
    3. Ger Plante

    1. Tracking hours and pay outstanding in spreadsheet 1

      • daamyour
    2. Replies
      1
      Views
      580
      1
    3. richadj4

    1. Subtracting time depending on text in a previous cell 13

      • CaulfieldS
    2. Replies
      13
      Views
      1.3k
      13
    3. AliGW

    1. Conditional Format Formula Help 1

      • gliffix101
    2. Replies
      1
      Views
      500
      1
    3. Infomage

    1. Trying to retrieve Data over multiple Rows and Columns 3

      • Trompie2017
    2. Replies
      3
      Views
      718
      3
    3. CaulfieldS

    1. Calculating the total commission value from a sliding scale 10

      • 3008300363
    2. Replies
      10
      Views
      1.3k
      10
    3. KjBox

    1. Associating a date with specific group of numbers 2

      • rsaha
    2. Replies
      2
      Views
      638
      2
    3. rsaha

    1. Fill Cell with Colour 1

      • prayaboutit2
    2. Replies
      1
      Views
      572
      1
    3. Logit

    1. Need To Alignment to The Right 1

      • azumi
    2. Replies
      1
      Views
      475
      1
    3. KjBox

    1. Finding specific columns and counting in them 2

      • andrej
    2. Replies
      2
      Views
      674
      2
    3. andrej

    1. Calculate Holidays with Networkdays 1

      • Wasiq
    2. Replies
      1
      Views
      808
      1
    3. Ger Plante

    1. Drop Down Menu with Two Possible Prefilled Scenarios 1

      • actinogen
    2. Replies
      1
      Views
      672
      1
    3. actinogen

    1. Addition based on the column heading 3

      • Snjpverma
    2. Replies
      3
      Views
      590
      3
    3. AliGW

    1. Delete Entry with 0 and entry beside it 5

      • JDmacromanZ
    2. Replies
      5
      Views
      1.2k
      5
    3. KjBox

    1. Stop Vlookup returning 0 2

      • Winwhite
    2. Replies
      2
      Views
      1.1k
      2
    3. Winwhite

Display Options