Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. How to remove unwanted test from string ? 1

      • Xani
      • Xani
    3. Replies
      1
      Views
      377
      1

    4. XenoCode

    2. Formula giving wrong total duration between two dates 2

      • Xani
      • Xani
    3. Replies
      2
      Views
      803
      2

    4. Xani

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

      • Xani
      • Xani
    3. Replies
      2
      Views
      773
      2

    4. Xani

    2. Return Total value from one sheet to another sheet depend on criteria ? 17

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

    4. NBVC

    2. Need to calculate status of each owner? 16

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

    4. KjBox

    2. Date conflict between two persons ? 1

      • Xani
    3. Replies
      1
      Views
      603
      1

    4. Carim

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

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

    4. Xani

    2. Copy rows of data to another worksheet if a condition is met in one of the cells 1

      • Wynnum
    3. Replies
      1
      Views
      667
      1

    4. bob22

    2. 3 Random Values from a list skipping blanks 2

      • wrigst
    3. Replies
      2
      Views
      1.7k
      2

    4. wrigst

    2. Vlookup using tabs with specific cell reference 2

      • wosborne
    3. Replies
      2
      Views
      1k
      2

    4. wosborne

    2. formula to remove all characters after a dash in a text string from the right 3

      • world33
    3. Replies
      3
      Views
      1.1k
      3

    4. Carim

    2. Copy row of data if column 1 is a certain number 1

      • woodstock1984
    3. Replies
      1
      Views
      531
      1

    4. NBVC

    2. Show a particular letter/value if a specific cell is included with one of the lists 2

      • woodstock1984
    3. Replies
      2
      Views
      456
      2

    4. woodstock1984

    2. Excel function to exclude a list dates/columns 5

      • wonka1234
    3. Replies
      5
      Views
      909
      5

    4. wonka1234

    2. COUNTIFS or SUMPRODUCT? Match criteria if other criteria is met. 3

      • Wobzy
    3. Replies
      3
      Views
      687
      3

    4. AliGW

    2. Complex INDEX and SMALL or MATCH based on muliple criteria 4

      • wizcreations
    3. Replies
      4
      Views
      590
      4

    4. AliGW

    2. Trouble w VLOOKUP (later in formula) displaying "0"s or #VALUE! 11

      • wittonline
    3. Replies
      11
      Views
      1.7k
      11

    4. wittonline

    2. Add an additional IF statement with a qualifying column value to existing formulas 3

      • wittonline
    3. Replies
      3
      Views
      636
      3

    4. wittonline

    2. Conditional Formatting: Trouble adding a col qualifier value into an existing formula 13

      • wittonline
    3. Replies
      13
      Views
      1.7k
      13

    4. wittonline

    2. MODE MATCH Formula (for most common occurance) not considering entire range 13

      • wittonline
    3. Replies
      13
      Views
      1.8k
      13

    4. wittonline

Label

Display Options