Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • khanaran
    3. Replies
      41
      Views
      3.2k
      41

    4. Carim

    2. Formula: Test for overlapping number ranges 3

      • jdawson422
    3. Replies
      3
      Views
      3k
      3

    4. p45cal

    2. PTO Accrual 27

      • pianolady30
    3. Replies
      27
      Views
      3k
      27

    4. Carim

    2. Blank cells replace zeros 30

      • CJamesUK
    3. Replies
      30
      Views
      2.9k
      30

    4. royUK

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

      • micvoo
    3. Replies
      9
      Views
      2.9k
      9

    4. micvoo

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

      • Delta729
    3. Replies
      2
      Views
      2.9k
      2

    4. Delta729

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

      • Washerz
    3. Replies
      1
      Views
      2.9k
      1

    4. Carim

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

      • onexc
    3. Replies
      11
      Views
      2.9k
      11

    4. onexc

    2. Custom searchable drop down list..... 8

      • nmkhan3010
    3. Replies
      8
      Views
      2.9k
      8

    4. GlennUK

    2. COUNTIFS with dynamic named ranges 14

      • Baber62
    3. Replies
      14
      Views
      2.8k
      14

    4. Baber62

    2. Counting unique rows 24

      • schweggen
    3. Replies
      24
      Views
      2.7k
      24

    4. loisdoig

    2. 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
    3. Replies
      19
      Views
      2.7k
      19

    4. sobi_256

    2. Ignore blank cells in array formula 2

      • artsjeroen
    3. Replies
      2
      Views
      2.7k
      2

    4. artsjeroen

    2. Extract data fields from wrapped text cell 7

      • hugletank
    3. Replies
      7
      Views
      2.6k
      7

    4. hugletank

    2. Revised vba to fill blanks in a range 19

      • kumarsatish
    3. Replies
      19
      Views
      2.6k
      19

    4. Carim

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

      • JadeRae
    3. Replies
      5
      Views
      2.6k
      5

    4. skywriter

    2. Finding the Median for certain dates from a list of data 12

      • moyad612013
    3. Replies
      12
      Views
      2.6k
      12

    4. NBVC

    2. Expand multilevel information 19

      • lsb2000
    3. Replies
      19
      Views
      2.6k
      19

    4. MandyRead

    2. Hide duplicate running total values. 11

      • Skylane60
    3. Replies
      11
      Views
      2.5k
      11

    4. Skylane60

    2. countifs with specific name between two dates 18

      • hahsj
    3. Replies
      18
      Views
      2.5k
      18

    4. MandyRead

Label

Display Options