Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. How to remove unwanted test from string ? 1

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

    1. Formula giving wrong total duration between two dates 2

      • Xani
      • Xani
    2. Replies
      2
      Views
      748
      2
    3. Xani

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

      • Xani
      • Xani
    2. Replies
      2
      Views
      739
      2
    3. Xani

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

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

    1. Need to calculate status of each owner? 16

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

    1. Date conflict between two persons ? 1

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

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

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

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

      • Wynnum
    2. Replies
      1
      Views
      646
      1
    3. bob22

    1. 3 Random Values from a list skipping blanks 2

      • wrigst
    2. Replies
      2
      Views
      1.5k
      2
    3. wrigst

    1. Vlookup using tabs with specific cell reference 2

      • wosborne
    2. Replies
      2
      Views
      994
      2
    3. wosborne

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

      • world33
    2. Replies
      3
      Views
      1k
      3
    3. Carim

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

      • woodstock1984
    2. Replies
      1
      Views
      508
      1
    3. NBVC

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

      • woodstock1984
    2. Replies
      2
      Views
      432
      2
    3. woodstock1984

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

      • wonka1234
    2. Replies
      5
      Views
      834
      5
    3. wonka1234

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

      • Wobzy
    2. Replies
      3
      Views
      653
      3
    3. AliGW

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

      • wizcreations
    2. Replies
      4
      Views
      547
      4
    3. AliGW

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

      • wittonline
    2. Replies
      11
      Views
      1.6k
      11
    3. wittonline

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

      • wittonline
    2. Replies
      3
      Views
      598
      3
    3. wittonline

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

      • wittonline
    2. Replies
      13
      Views
      1.6k
      13
    3. wittonline

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

      • wittonline
    2. Replies
      13
      Views
      1.7k
      13
    3. wittonline

Label

Display Options