Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Add leading 0 only after letters 3

      • backgroundbook
    2. Replies
      3
      Views
      280
      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
      709
      19
    3. sobi_256

    1. Separation Formula Required 2

      • ShoaibRajput1
    2. Replies
      2
      Views
      204
      2
    3. royUK

    1. Finding the earliest date/time when all tests parameters meet their respective targets (pass) 2

      • alex_a
    2. Replies
      2
      Views
      183
      2
    3. alex_a

    1. Converting Text to Time 7

      • TBro
      • TBro
    2. Replies
      7
      Views
      247
      7
    3. royUK

    1. Remove Rows Based on Partial Duplicates For Email Marketing Like Mail Chimp 2

      • ChrisGator
    2. Replies
      2
      Views
      168
      2
    3. ChrisGator

    1. Custom Week Number - Last Saturday in December is Week 1 23

      • m4Owen
    2. Replies
      23
      Views
      1.1k
      23
    3. Carim

    1. Vlookup to pull a data from adjacent column 5

      • Billyrj
    2. Replies
      5
      Views
      307
      5
    3. MandyRead

    1. Formulas Convert to Numbers Automatically 5

      • d c
      • d c
    2. Replies
      5
      Views
      308
      5
    3. MandyRead

    1. Look for No or NO in a string and count 7

      • DezB
    2. Replies
      7
      Views
      432
      7
    3. MandyRead

    1. Return Value in External Workbook with Concatenated Filename, Sheet, and Cell String 6

      • RECOChris
    2. Replies
      6
      Views
      408
      6
    3. MandyRead

    1. double click macro for table 10

      • nitroxhaha
    2. Replies
      10
      Views
      598
      10
    3. MandyRead

    1. countifs with specific name between two dates 18

      • hahsj
    2. Replies
      18
      Views
      869
      18
    3. MandyRead

    1. Sum across variable columns for a specific store 6

      • IvanYerk
    2. Replies
      6
      Views
      272
      6
    3. MandyRead

    1. extracting data from a sentence-please needed ASAP 8

      • zohar
    2. Replies
      8
      Views
      357
      8
    3. MandyRead

    1. Expand multilevel information 19

      • lsb2000
    2. Replies
      19
      Views
      872
      19
    3. MandyRead

    1. Divide range of cells in one column by range in same column depending on range in another column meeting certain criteria 5

      • feefeecool
    2. Replies
      5
      Views
      268
      5
    3. MandyRead

    1. INCREMENT NUMERICAL STRING BY 1 17

      • Garth Lean
    2. Replies
      17
      Views
      672
      17
    3. MandyRead

    1. Auto Fill Cells And Formula 8

      • jasonsgroovemachine
    2. Replies
      8
      Views
      236
      8
    3. MandyRead

    1. Change price result based on multiple date transactions 6

      • GaryTait
    2. Replies
      6
      Views
      161
      6
    3. MandyRead

Display Options