Threads by mljohn
-
- Title
- Replies
- Last Reply
-
-
-
Adjust Lookup formula to find first entry 3
- mljohn
June 10, 2021 at 3:23 PM - Excel Formulas
- mljohn
June 10, 2021 at 5:26 PM
-
- Replies
- 3
- Views
- 596
3
-
-
-
-
Remove non-numeric characters before first numeric character 3
- mljohn
June 9, 2021 at 10:53 PM - Excel Formulas
- mljohn
June 10, 2021 at 1:22 PM
-
- Replies
- 3
- Views
- 619
3
-
-
-
-
Xlookup or Index/Match with two criteria 7
- mljohn
April 5, 2021 at 8:14 PM - Excel Formulas
- mljohn
April 7, 2021 at 6:03 AM
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
Find common part number amongst various suppiers 1
- mljohn
March 24, 2021 at 10:16 PM - Excel Formulas
- mljohn
March 24, 2021 at 11:47 PM
-
- Replies
- 1
- Views
- 417
1
-
-
-
-
index match first non blank cell 1
- mljohn
September 17, 2019 at 9:27 PM - Excel Formulas
- mljohn
September 18, 2019 at 7:52 AM
-
- Replies
- 1
- Views
- 454
1
-
-
-
-
Remove Duplicates wont work 8
- mljohn
September 5, 2019 at 1:54 PM - Excel General
- mljohn
February 19, 2020 at 4:00 PM
-
- Replies
- 8
- Views
- 1.8k
8
-
-
-
-
Count non blanks 5 years from the last non blank date 3
- mljohn
May 14, 2019 at 3:08 PM - Excel General
- mljohn
May 15, 2019 at 2:24 PM
-
- Replies
- 3
- Views
- 852
3
-
-
-
-
# days in range of dates that includes some duplicates separated by two blank rows 8
- mljohn
August 6, 2018 at 6:05 PM - Excel General
- mljohn
August 7, 2018 at 7:33 PM
-
- Replies
- 8
- Views
- 1.4k
8
-
-
-
-
Now() formatting error 1
- mljohn
May 14, 2018 at 5:17 PM - Excel General
- mljohn
May 14, 2018 at 6:29 PM
-
- Replies
- 1
- Views
- 351
1
-
-
-
-
Find data in one cell that matches or partially matches another cell in another sheet 2
- mljohn
March 9, 2018 at 4:07 PM - Excel General
- mljohn
March 10, 2018 at 4:31 PM
-
- Replies
- 2
- Views
- 446
2
-
-
-
-
Dynamically create range 3 years from TODAY for formula 9
- mljohn
August 7, 2017 at 4:24 PM - Excel Formulas
- mljohn
August 9, 2017 at 1:10 AM
-
- Replies
- 9
- Views
- 1.5k
9
-
-
-
-
Adjust formula from last to first 2
- mljohn
June 26, 2017 at 5:57 PM - Excel General
- mljohn
June 26, 2017 at 7:27 PM
-
- Replies
- 2
- Views
- 576
2
-
-
-
-
Add to column of cells all part numbers with a price 3
- mljohn
December 8, 2016 at 3:45 PM - Excel General
- mljohn
December 8, 2016 at 7:51 PM
-
- Replies
- 3
- Views
- 877
3
-
-
-
-
Find product price from appropriate vendor from all vendors 2
- mljohn
December 2, 2016 at 5:32 PM - Excel Formulas
- mljohn
December 3, 2016 at 12:10 AM
-
- Replies
- 2
- Views
- 719
2
-
-
-
-
Correct part number in a formula from multiple part numbers in a cell 2
- mljohn
August 25, 2015 at 10:20 PM - Excel General
- mljohn
August 28, 2015 at 11:16 PM
-
- Replies
- 2
- Views
- 1.4k
2
-
-
-
-
Count and Average 4
- mljohn
June 3, 2015 at 10:16 PM - Excel General
- mljohn
June 5, 2015 at 4:45 PM
-
- Replies
- 4
- Views
- 1.4k
4
-
-
-
-
Average time for last 3 years 3
- mljohn
May 28, 2015 at 4:47 PM - Excel General
- mljohn
May 30, 2015 at 12:47 AM
-
- Replies
- 3
- Views
- 1.3k
3
-
-
-
-
Sumif match in two sheets 7
- mljohn
May 19, 2015 at 9:26 PM - Excel General
- mljohn
May 22, 2015 at 10:58 AM
-
- Replies
- 7
- Views
- 2.7k
7
-
-
-
-
Find last non zero cell in row 2 and show column label in row 1 3
- mljohn
July 23, 2014 at 10:00 PM - Excel General
- mljohn
July 24, 2014 at 3:55 PM
-
- Replies
- 3
- Views
- 1.9k
3
-
-
-
-
How to calculate groups of data between two blank rows 1
- mljohn
November 22, 2013 at 4:08 PM - Excel General
- mljohn
November 22, 2013 at 4:15 PM
-
- Replies
- 1
- Views
- 1k
1
-