Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Formula: Test for overlapping number ranges 3

      • jdawson422
    2. Replies
      3
      Views
      2.7k
      3
    3. p45cal

    1. PTO Accrual 27

      • pianolady30
    2. Replies
      27
      Views
      2.6k
      27
    3. Carim

    1. COUNTIFS with dynamic named ranges 14

      • Baber62
    2. Replies
      14
      Views
      2.6k
      14
    3. Baber62

    1. Match a value against a date and enter the matched value 41

      • khanaran
    2. Replies
      41
      Views
      2.5k
      41
    3. Carim

    1. Determine if "Active" if hire and term date are within cells range 2

      • Delta729
    2. Replies
      2
      Views
      2.5k
      2
    3. Delta729

    1. Ignore blank cells in array formula 2

      • artsjeroen
    2. Replies
      2
      Views
      2.5k
      2
    3. artsjeroen

    1. Custom searchable drop down list..... 8

      • nmkhan3010
    2. Replies
      8
      Views
      2.5k
      8
    3. GlennUK

    1. Drag down formula and change column names in order 11

      • onexc
    2. Replies
      11
      Views
      2.5k
      11
    3. onexc

    1. Blank cells replace zeros 30

      • CJamesUK
    2. Replies
      30
      Views
      2.5k
      30
    3. royUK

    1. Counting unique rows 24

      • schweggen
    2. Replies
      24
      Views
      2.5k
      24
    3. loisdoig

    1. Xlookup with duplicate values in return array 3

      • Aksaunder
    2. Replies
      3
      Views
      2.4k
      3
    3. Carim

    1. How to create an excel formula that will average the 2 highest values that are separated by a 3 week difference in testing date 19

      • healthguy
    2. Replies
      19
      Views
      2.4k
      19
    3. sobi_256

    1. Return Specific Value from adjacent cell if values match 5

      • JadeRae
    2. Replies
      5
      Views
      2.4k
      5
    3. skywriter

    1. VLookup Formula that can change Negative number to Positive and leave Positive 1

      • Washerz
    2. Replies
      1
      Views
      2.4k
      1
    3. Carim

    1. Expand multilevel information 19

      • lsb2000
    2. Replies
      19
      Views
      2.3k
      19
    3. MandyRead

    1. Revised vba to fill blanks in a range 19

      • kumarsatish
    2. Replies
      19
      Views
      2.3k
      19
    3. Carim

    1. growing range 7

      • Eusebious
    2. Replies
      7
      Views
      2.3k
      7
    3. Eusebious

    1. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    2. Replies
      12
      Views
      2.3k
      12
    3. B.W.B.

    1. Extract data fields from wrapped text cell 7

      • hugletank
    2. Replies
      7
      Views
      2.2k
      7
    3. hugletank

    1. If cell is not empty, copy row... 9

      • micvoo
    2. Replies
      9
      Views
      2.2k
      9
    3. micvoo

Display Options