Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. YTD using dynamic spilled array 11

      • MatthewHart
    3. Replies
      11
      Views
      2.1k
      11

    4. AliGW

    2. YTD Figures 3

      • mar050703
    3. Replies
      3
      Views
      1.3k
      3

    4. AliGW

    2. YTD calculations with multiple criteria 7

      • EExcelHelp
    3. Replies
      7
      Views
      1.9k
      7

    4. Carim

    2. Xlookup with duplicate values in return array 3

      • Aksaunder
    3. Replies
      3
      Views
      3.7k
      3

    4. Carim

    2. Xlookup or Index/Match with two criteria 7

      • mljohn
    3. Replies
      7
      Views
      798
      7

    4. Carim

    2. xlookup multiple criteria? 2

      • browncoat
    3. Replies
      2
      Views
      2k
      2

    4. gyankosh.net

    2. xlookup by all words in a string

      • jbristow
    3. Replies
      0
      Views
      112

    2. write formula in work sheet 7

      • supriyamk
    3. Replies
      7
      Views
      654
      7

    4. Carim

    2. Would like to use HLOOKUP() instead of using many Range Names 5

      • NGM
      • NGM
    3. Replies
      5
      Views
      816
      5

    4. AliGW

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.3k
      21

    4. LearningXL

    2. World Cup Wallchart 1

      • Garyhunt6809
    3. Replies
      1
      Views
      614
      1

    4. Garyhunt6809

    2. Workdays in the Month formula? [SOLVED] 1

      • Johnnyv015
    3. Replies
      1
      Views
      402
      1

    4. Johnnyv015

    2. Wins in the Last 5 4

      • showtimesaints
    3. Replies
      4
      Views
      700
      4

    4. royUK

    2. When G matches B, count the number of values in C (that do not match H) 5

      • BJL
      • BJL
    3. Replies
      5
      Views
      941
      5

    4. BJL

    2. What was the average of their last three sales 4

      • 1003064
    3. Replies
      4
      Views
      521
      4

    4. JonathanVH

    2. What is the average overall letter grade? 4

      • DrRandyman
    3. Replies
      4
      Views
      1.4k
      4

    4. Logit

    2. WEEKNUM system 1 and 2 2

      • arabella
    3. Replies
      2
      Views
      1.3k
      2

    4. arabella

    2. WEEKDAYNAME function not working... error #NAME? (Excel 2013) 1

      • Dougmeister
    3. Replies
      1
      Views
      827
      1

    4. NBVC

    2. Way to calculate number of days within months from dates in table 4

      • Matt168
    3. Replies
      4
      Views
      466
      4

    4. Matt168

    2. Water Billing Rates Formula 2

      • EvanBerrett
    3. Replies
      2
      Views
      1.6k
      2

    4. EvanBerrett

Label

Display Options