Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

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

    1. Drop Down Menu with Two Possible Prefilled Scenarios 1

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

    1. Associating a date with specific group of numbers 2

      • rsaha
    2. Replies
      2
      Views
      627
      2
    3. rsaha

    1. Delete Entry with 0 and entry beside it 5

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

    1. Fill Cell with Colour 1

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

    1. Calculate Holidays with Networkdays 1

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

    1. Need To Alignment to The Right 1

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

    1. Finding specific columns and counting in them 2

      • andrej
    2. Replies
      2
      Views
      659
      2
    3. andrej

    1. Addition based on the column heading 3

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

    1. Cross reference with 2 Variables 1

      • JDmacromanZ
    2. Replies
      1
      Views
      414
      1
    3. Ger Plante

    1. Stop Vlookup returning 0 2

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

    1. vLookup not working. 2

      • Clayhead22
    2. Replies
      2
      Views
      480
      2
    3. JDmacromanZ

    1. Drag Down Formula, but only change worksheet number 1

      • sarasalinas2011
    2. Replies
      1
      Views
      555
      1
    3. FDibbins

    1. Summing up until matching target figure 9

      • nairrb
    2. Replies
      9
      Views
      1.3k
      9
    3. nairrb

    1. decimal value derived through formula acting as text, how to make it as value 5

      • analystbank
    2. Replies
      5
      Views
      1.4k
      5
    3. AAE

    1. Calculate overtime based on 8 hour day / 44 hour week 10

      • Excel Noob
    2. Replies
      10
      Views
      4.5k
      10
    3. Infomage

    1. Unique rank with multiple criteria 1

      • hydebedi
    2. Replies
      1
      Views
      1.2k
      1
    3. NBVC

    1. Sum columns based on mutiple criteria 1

      • shani75
    2. Replies
      1
      Views
      552
      1
    3. AliGW

    1. vlookup #n/a error when values exist 5

      • ANku86
    2. Replies
      5
      Views
      7.3k
      5
    3. KjBox

Display Options