Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Finding specific columns and counting in them 2

      • andrej
    2. Replies
      2
      Views
      654
      2
    3. andrej

    1. Calculate Holidays with Networkdays 1

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

    1. Drop Down Menu with Two Possible Prefilled Scenarios 1

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

    1. Addition based on the column heading 3

      • Snjpverma
    2. Replies
      3
      Views
      572
      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
      1k
      2
    3. Winwhite

    1. Cross reference with 2 Variables 1

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

    1. vLookup not working. 2

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

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

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

    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. Sum columns based on mutiple criteria 1

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

    1. Summing up until matching target figure 9

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

    1. Unique rank with multiple criteria 1

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

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

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

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

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

    1. using 2 multi conditional if then statements based on value of another cell 11

      • trader1588
    2. Replies
      11
      Views
      1.3k
      11
    3. AliGW

    1. Count - Attendance Formula 5

      • ryaneschroeder
    2. Replies
      5
      Views
      1.5k
      5
    3. AAE

    1. Sum non-consecutive/contiguous cells by Month and Year 5

      • tac_79
    2. Replies
      5
      Views
      1.9k
      5
    3. tac_79

    1. Listing Unique Names 2

      • cvgtang
    2. Replies
      2
      Views
      1k
      2
    3. AAE

    1. YTD Figures 3

      • mar050703
    2. Replies
      3
      Views
      1.1k
      3
    3. AliGW

Display Options