Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

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

      • yogeshtalks
    3. Replies
      8
      Views
      2.1k
      8

    4. NBVC

    2. How do I average multiple columns (ignoring zeros and blank cells)? 1

      • yeto
    3. Replies
      1
      Views
      833
      1

    4. Carim

    2. Search Cell for Specific Characters 3

      • Yeppy12
    3. Replies
      3
      Views
      691
      3

    4. Yeppy12

    2. Unique (text) value for Randbetween 4

      • XXX7
      • XXX7
    3. Replies
      4
      Views
      755
      4

    4. KjBox

    2. Multiple returns with 2 criteria from another workbook 15

      • xsmurf
    3. Replies
      15
      Views
      1.1k
      15

    4. Carim

    2. Variable Cell Reference based on Path 9

      • xlbrian
    3. Replies
      9
      Views
      1.3k
      9

    4. Carim

    2. Find adj. cells with specific text strings. Return a text string based on findings. 1

      • XJmikeT
    3. Replies
      1
      Views
      523
      1

    4. S M C

    2. Display selection based on a value in another cell 5

      • xcel4me
    3. Replies
      5
      Views
      1.6k
      5

    4. xcel4me

    2. Using Countif to calculate totals from another excel tab 1

      • Xani
      • Xani
    3. Replies
      1
      Views
      254
      1

    4. alansidman

    2. Calculate Total Times Ticket Open 4

      • Xani
      • Xani
    3. Replies
      4
      Views
      570
      4

    4. alansidman

    2. How to make drop down menu by showing staff name and staff id ? 3

      • Xani
      • Xani
    3. Replies
      3
      Views
      476
      3

    4. royUK

    2. ​Calculate Duration between two dates 2

      • Xani
    3. Replies
      2
      Views
      451
      2

    4. Xani

    2. Dropdown Menu & VLookup formula not working 9

      • Xani
      • Xani
    3. Replies
      9
      Views
      1.2k
      9

    4. Xani

    2. How to calculate variance and ratio total open and closed tickets? 1

      • Xani
      • Xani
    3. Replies
      1
      Views
      472
      1

    4. Carim

    2. How to get total days which it is Reported Date - Actual Finish? 2

      • Xani
      • Xani
    3. Replies
      2
      Views
      665
      2

    4. sobi_256

    2. How to return total queued amount to specific owner name field ? 4

      • Xani
      • Xani
    3. Replies
      4
      Views
      704
      4

    4. Xani

    2. How to show if two labors having conflict dates of leave?

      • Xani
      • Xani
    3. Replies
      0
      Views
      160

    2. How to show if two labors having conflict dates of leave? 1

      • Xani
      • Xani
    3. Replies
      1
      Views
      201
      1

    4. Xani

    2. How to show if two labors having conflict dates of leave?

      • Xani
      • Xani
    3. Replies
      0
      Views
      143

    2. Check if two columns match or not 5

      • Xani
      • Xani
    3. Replies
      5
      Views
      693
      5

    4. Carim

Label

Display Options