Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Find the max value if the value is not struck through 5

      • hmsiegel
    2. Replies
      5
      Views
      1.9k
      5
    3. skywriter

    1. if isnumber search and iserror vlookup index match - used together. 2

      • Emile du Toit
    2. Replies
      2
      Views
      1.9k
      2
    3. Emile du Toit

    1. Need to calculate status of each owner? 16

      • Xani
      • Xani
    2. Replies
      16
      Views
      1.9k
      16
    3. KjBox

    1. Trying to use data bar formatting 10

      • excelhatesme!
    2. Replies
      10
      Views
      2k
      10
    3. 63falcondude

    1. change IPV6 addresses last and second last octet 8

      • ganesh_6663
    2. Replies
      8
      Views
      2k
      8
    3. ganesh_6663

    1. Dependent dropdown lists with multiple words in the different sheets 17

      • onexc
    2. Replies
      17
      Views
      2k
      17
    3. Carim

    1. Sum Area Based on Compound Row and Column Criteria 13

      • DC Mega
    2. Replies
      13
      Views
      2k
      13
    3. Carim

    1. Count number of dates by month 4

      • DezB
      • DezB
    2. Replies
      4
      Views
      2k
      4
    3. royUK

    1. YTD calculations with multiple criteria 7

      • EExcelHelp
    2. Replies
      7
      Views
      2k
      7
    3. Carim

    1. Calculate time if greater than specific time in excel? 16

      • Xani
      • Xani
    2. Replies
      16
      Views
      2k
      16
    3. Xani

    1. Data Validation and Formula in the same cell 8

      • jpetraityte
    2. Replies
      8
      Views
      2k
      8
    3. royUK

    1. Double counting in SUMPRODUCT formula 11

      • Luis Ah-Hoy Jr.
    2. Replies
      11
      Views
      2k
      11
    3. Luis Ah-Hoy Jr.

    1. sorting and presenting top values only once 22

      • nircom
    2. Replies
      22
      Views
      2.1k
      22
    3. Carim

    1. excel dynamic hyperlink to web address is not dynamic at all using HYPERLINK function 8

      • CptnKirk
    2. Replies
      8
      Views
      2.1k
      8
    3. Carim

    1. xlookup multiple criteria? 2

      • browncoat
    2. Replies
      2
      Views
      2.1k
      2
    3. gyankosh.net

    1. Using a value from a cell inside a formula 8

      • yogeshtalks
    2. Replies
      8
      Views
      2.1k
      8
    3. NBVC

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      2.1k
      7
    3. XOR LX

    1. Positive Correlation but Negative correlation in Regression. 4

      • Jontini
    2. Replies
      4
      Views
      2.1k
      4
    3. pike

    1. alert levels 12

      • zohar
    2. Replies
      12
      Views
      2.1k
      12
    3. zohar

    1. Highlight largest value cell in range based on other columns 15

      • paul789
    2. Replies
      15
      Views
      2.1k
      15
    3. AliGW

Label

Display Options