Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

    1. Need to calculate status of each owner? 16

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

    1. Date conflict between two persons ? 1

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

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

      • Xani
      • Xani
    2. Replies
      16
      Views
      1.7k
      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
      610
      1
    3. bob22

    1. 3 Random Values from a list skipping blanks 2

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

    1. Vlookup using tabs with specific cell reference 2

      • wosborne
    2. Replies
      2
      Views
      915
      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
      907
      3
    3. Carim

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

      • woodstock1984
    2. Replies
      1
      Views
      452
      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
      395
      2
    3. woodstock1984

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

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

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

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

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

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

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

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

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

      • wittonline
    2. Replies
      3
      Views
      513
      3
    3. wittonline

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

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

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

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

    1. Trying to get AVE &SUM, considering code in the calcs; not dependent on specific cols 1

      • wittonline
    2. Replies
      1
      Views
      472
      1
    3. wittonline

    1. Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9

      • wittonline
    2. Replies
      9
      Views
      1.2k
      9
    3. wittonline

    1. Stop Vlookup returning 0 2

      • Winwhite
    2. Replies
      2
      Views
      1.1k
      2
    3. Winwhite

Display Options