Threads by mljohn

    1. Title
    2. Replies
    3. Last Reply

    2. Adjust Lookup formula to find first entry 3

      • mljohn
    3. Replies
      3
      Views
      505
      3

    4. bosco_yip

    2. Remove non-numeric characters before first numeric character 3

      • mljohn
    3. Replies
      3
      Views
      512
      3

    4. mljohn

    2. Xlookup or Index/Match with two criteria 7

      • mljohn
    3. Replies
      7
      Views
      1k
      7

    4. Carim

    2. Find common part number amongst various suppiers 1

      • mljohn
    3. Replies
      1
      Views
      362
      1

    4. alansidman

    2. index match first non blank cell 1

      • mljohn
    3. Replies
      1
      Views
      404
      1

    4. Carim

    2. Remove Duplicates wont work 8

      • mljohn
    3. Replies
      8
      Views
      1.5k
      8

    4. alansidman

    2. Count non blanks 5 years from the last non blank date 3

      • mljohn
    3. Replies
      3
      Views
      762
      3

    4. mljohn

    2. # days in range of dates that includes some duplicates separated by two blank rows 8

      • mljohn
    3. Replies
      8
      Views
      1.2k
      8

    4. Carim

    2. Now() formatting error 1

      • mljohn
    3. Replies
      1
      Views
      288
      1

    4. NBVC

    2. Find data in one cell that matches or partially matches another cell in another sheet 2

      • mljohn
    3. Replies
      2
      Views
      393
      2

    4. mljohn

    2. Dynamically create range 3 years from TODAY for formula 9

      • mljohn
    3. Replies
      9
      Views
      1.3k
      9

    4. skywriter

    2. Adjust formula from last to first 2

      • mljohn
    3. Replies
      2
      Views
      512
      2

    4. mljohn

    2. Add to column of cells all part numbers with a price 3

      • mljohn
    3. Replies
      3
      Views
      786
      3

    4. alansidman

    2. Find product price from appropriate vendor from all vendors 2

      • mljohn
    3. Replies
      2
      Views
      658
      2

    4. mljohn

    2. Correct part number in a formula from multiple part numbers in a cell 2

      • mljohn
    3. Replies
      2
      Views
      1.3k
      2

    4. pike

    2. Count and Average 4

      • mljohn
    3. Replies
      4
      Views
      1.4k
      4

    4. mljohn

    2. Average time for last 3 years 3

      • mljohn
    3. Replies
      3
      Views
      1.3k
      3

    4. mljohn

    2. Sumif match in two sheets 7

      • mljohn
    3. Replies
      7
      Views
      2.6k
      7

    4. sylwester.cz

    2. Find last non zero cell in row 2 and show column label in row 1 3

      • mljohn
    3. Replies
      3
      Views
      1.9k
      3

    4. mljohn

    2. How to calculate groups of data between two blank rows 1

      • mljohn
    3. Replies
      1
      Views
      978
      1

    4. patel