Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Generate cells with values from other cells 19

      • DataWarrior
    3. Replies
      19
      Views
      3.4k
      19

    4. DataWarrior

    2. Sumifs to sum qty's from 3 different columns with same criteria 19

      • Freddyfroo
    3. Replies
      19
      Views
      2.4k
      19

    4. KjBox

    2. MATCH Function seems to hate me. 19

      • ken054
    3. Replies
      19
      Views
      1.8k
      19

    4. AliGW

    2. # of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19

      • AcctgController
    3. Replies
      19
      Views
      1.7k
      19

    4. George-1947

    2. Revised vba to fill blanks in a range 19

      • kumarsatish
    3. Replies
      19
      Views
      2.8k
      19

    4. Carim

    2. Expand multilevel information 19

      • lsb2000
    3. Replies
      19
      Views
      2.7k
      19

    4. MandyRead

    2. How to create an excel formula that will average the 2 highest values that are separated by a 3 week difference in testing date 19

      • healthguy
    3. Replies
      19
      Views
      2.8k
      19

    4. sobi_256

    2. FILTER and UNIQUE - dependent dropdown lists... 19

      • paulbiddis
    3. Replies
      19
      Views
      1.8k
      19

    4. Carim

    2. Find Max number value from text-number cell? 20

      • B.W.B.
    3. Replies
      20
      Views
      3.7k
      20

    4. XOR LX

    2. Count number of consecutive values based on criteria 20

      • Nathan_E
    3. Replies
      20
      Views
      16k
      20

    4. NBVC

    2. COUNT two or more consecutive text values and check each if it's +/- than a value 20

      • aspasovski86
    3. Replies
      20
      Views
      1.9k
      20

    4. Carim

    2. sum cells in an excel column that fall between cells that fit a specific criteria? 20

      • Laura Garnham
    3. Replies
      20
      Views
      1.5k
      20

    4. Carim

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.3k
      21

    4. LearningXL

    2. Formula to convert a gregorian date to a chinese date 21

      • khanaran
    3. Replies
      21
      Views
      7.2k
      21

    4. bosco_yip

    2. Select Odd Rows from Named Range 21

      • Cobstillaware
    3. Replies
      21
      Views
      1.6k
      21

    4. Carim

    2. sorting and presenting top values only once 22

      • nircom
    3. Replies
      22
      Views
      2.1k
      22

    4. Carim

    2. I want Vlookup to return Formula and take cell reference from Target sheet. 22

      • nilaymohit
    3. Replies
      22
      Views
      4.2k
      22

    4. MandyRead

    2. Custom Week Number - Last Saturday in December is Week 1 23

      • m4Owen
    3. Replies
      23
      Views
      5k
      23

    4. Carim

    2. Auto populating drop down lists/cells based on conditions 24

      • Boycie92
    3. Replies
      24
      Views
      2.6k
      24

    4. AliGW

    2. Copy data down and across range 24

      • jl2509
    3. Replies
      24
      Views
      2.4k
      24

    4. Carim

Label

Display Options