Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Vlookup with dynamic capabilities 9

      • RobertJ
    3. Replies
      9
      Views
      1.4k
      9

    4. Carim

    2. Water Billing Rates Formula 2

      • EvanBerrett
    3. Replies
      2
      Views
      2.1k
      2

    4. EvanBerrett

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

      • Matt168
    3. Replies
      4
      Views
      543
      4

    4. Matt168

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

      • Dougmeister
    3. Replies
      1
      Views
      923
      1

    4. NBVC

    2. WEEKNUM system 1 and 2 2

      • arabella
    3. Replies
      2
      Views
      1.6k
      2

    4. arabella

    2. What is the average overall letter grade? 4

      • DrRandyman
    3. Replies
      4
      Views
      2.1k
      4

    4. Logit

    2. What is wrong with this formula?? 7

      • DezB
      • DezB
    3. Replies
      7
      Views
      222
      7

    4. Carim

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

      • 1003064
    3. Replies
      4
      Views
      610
      4

    4. JonathanVH

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

      • BJL
      • BJL
    3. Replies
      5
      Views
      1.1k
      5

    4. BJL

    2. Wilcard for vlookup

      • Pedro003
    3. Replies
      0
      Views
      258

    2. Wins in the Last 5 4

      • showtimesaints
    3. Replies
      4
      Views
      853
      4

    4. royUK

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

      • Johnnyv015
    3. Replies
      1
      Views
      435
      1

    4. Johnnyv015

    2. World Cup Wallchart 1

      • Garyhunt6809
    3. Replies
      1
      Views
      701
      1

    4. Garyhunt6809

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.5k
      21

    4. LearningXL

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

      • NGM
      • NGM
    3. Replies
      5
      Views
      930
      5

    4. AliGW

    2. write formula in work sheet 7

      • supriyamk
    3. Replies
      7
      Views
      763
      7

    4. Carim

    2. XLOOKUP #VALUE Error :-( 4

      • DezB
      • DezB
    3. Replies
      4
      Views
      66
      4

    4. DezB

    2. xlookup by all words in a string

      • jbristow
    3. Replies
      0
      Views
      212

    2. xlookup multiple criteria? 2

      • browncoat
    3. Replies
      2
      Views
      2.2k
      2

    4. gyankosh.net

    2. Xlookup or Index/Match with two criteria 7

      • mljohn
    3. Replies
      7
      Views
      1k
      7

    4. Carim

Label

Display Options