Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

      • yeto
    2. Replies
      1
      Views
      500
      1
    3. Carim

    1. Search Cell for Specific Characters 3

      • Yeppy12
    2. Replies
      3
      Views
      518
      3
    3. Yeppy12

    1. Unique (text) value for Randbetween 4

      • XXX7
      • XXX7
    2. Replies
      4
      Views
      564
      4
    3. KjBox

    1. Variable Cell Reference based on Path 9

      • xlbrian
    2. Replies
      9
      Views
      913
      9
    3. Carim

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

      • XJmikeT
    2. Replies
      1
      Views
      364
      1
    3. S M C

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

      • xcel4me
    2. Replies
      5
      Views
      1.3k
      5
    3. xcel4me

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

      • Xani
      • Xani
    2. Replies
      3
      Views
      169
      3
    3. royUK

    1. ​Calculate Duration between two dates 2

      • Xani
    2. Replies
      2
      Views
      189
      2
    3. Xani

    1. Dropdown Menu & VLookup formula not working 9

      • Xani
      • Xani
    2. Replies
      9
      Views
      603
      9
    3. Xani

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

      • Xani
      • Xani
    2. Replies
      1
      Views
      248
      1
    3. Carim

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

      • Xani
      • Xani
    2. Replies
      2
      Views
      493
      2
    3. sobi_256

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

      • Xani
      • Xani
    2. Replies
      4
      Views
      501
      4
    3. Xani

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

      • Xani
      • Xani
    2. Replies
      0
      Views
      97
    1. How to show if two labors having conflict dates of leave? 1

      • Xani
      • Xani
    2. Replies
      1
      Views
      104
      1
    3. Xani

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

      • Xani
      • Xani
    2. Replies
      0
      Views
      67
    1. Check if two columns match or not 5

      • Xani
      • Xani
    2. Replies
      5
      Views
      476
      5
    3. Carim

    1. How to remove unwanted test from string ? 1

      • Xani
      • Xani
    2. Replies
      1
      Views
      258
      1
    3. XenoCode

    1. Formula giving wrong total duration between two dates 2

      • Xani
      • Xani
    2. Replies
      2
      Views
      641
      2
    3. Xani

    1. Formula to calculate duration difference between two dates ? 2

      • Xani
      • Xani
    2. Replies
      2
      Views
      555
      2
    3. Xani

Display Options