Excel Formulas

Questions related specifically to the use of Excel formulas.

    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
      625
      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
      566
      1
    3. Logit

    1. Calculate Holidays with Networkdays 1

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

    1. Need To Alignment to The Right 1

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

    1. Finding specific columns and counting in them 2

      • andrej
    2. Replies
      2
      Views
      655
      2
    3. andrej

    1. Addition based on the column heading 3

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

    1. Cross reference with 2 Variables 1

      • JDmacromanZ
    2. Replies
      1
      Views
      411
      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
      479
      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.4k
      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
      548
      1
    3. AliGW

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

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

    1. Sum two columns with changing ranges 4

      • juanluisl
    2. Replies
      4
      Views
      1.3k
      4
    3. juanluisl

    1. Excel says: You've entered too many arguments for this function: 4

      • Trish123
    2. Replies
      4
      Views
      4.6k
      4
    3. AAE

Display Options