Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Match a value against a date and enter the matched value 41

      • khanaran
    3. Replies
      41
      Views
      3.8k
      41

    4. Carim

    2. Blank cells replace zeros 30

      • CJamesUK
    3. Replies
      30
      Views
      3.4k
      30

    4. royUK

    2. Multiple returns with 2 criteria from another workbook 29

      • xsmurf
    3. Replies
      29
      Views
      1.7k
      29

    4. xsmurf

    2. Exact same formula different results. 28

      • her.rockstar
    3. Replies
      28
      Views
      4k
      28

    4. NBVC

    2. PTO Accrual 27

      • pianolady30
    3. Replies
      27
      Views
      3.3k
      27

    4. Carim

    2. Excel-Weighted Average using Words, NOT Numbers! 26

      • mariadnj
    3. Replies
      26
      Views
      1.8k
      26

    4. AliGW

    2. How to use indirect formula to show value AND formatting? 26

      • carissa
    3. Replies
      26
      Views
      4.6k
      26

    4. Carim

    2. Counting unique rows 24

      • schweggen
    3. Replies
      24
      Views
      2.8k
      24

    4. loisdoig

    2. Copy data down and across range 24

      • jl2509
    3. Replies
      24
      Views
      2.6k
      24

    4. Carim

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

      • Boycie92
    3. Replies
      24
      Views
      2.6k
      24

    4. AliGW

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

      • m4Owen
    3. Replies
      23
      Views
      5.2k
      23

    4. Carim

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

      • nilaymohit
    3. Replies
      22
      Views
      4.3k
      22

    4. MandyRead

    2. sorting and presenting top values only once 22

      • nircom
    3. Replies
      22
      Views
      2.2k
      22

    4. Carim

    2. Select Odd Rows from Named Range 21

      • Cobstillaware
    3. Replies
      21
      Views
      2k
      21

    4. Carim

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

      • khanaran
    3. Replies
      21
      Views
      8k
      21

    4. bosco_yip

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      2.5k
      21

    4. LearningXL

    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. COUNT two or more consecutive text values and check each if it's +/- than a value 20

      • aspasovski86
    3. Replies
      20
      Views
      2k
      20

    4. Carim

    2. Count number of consecutive values based on criteria 20

      • Nathan_E
    3. Replies
      20
      Views
      17k
      20

    4. NBVC

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

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

    4. XOR LX

Label

Display Options