Uploaded June 2016 | Updated September 2026, 54 minutes ago
Find a sequence of words in range of messy text.
Get Excel file 00150 here: http://1drv.ms/1bYwrTa
00:00 Intro
00:39 Requirement #1 Find feature & Countif
02:24 Requirement #2 intro
03:24 Requirement #2 Using Find feature
05:34 Requirement #2 Dynamic requirement description
06:07 Requirement #2 Dynamic Formula!
09:00 Requirement #2 Dynamic hyperlink!
My Post: myspreadsheetlab.com/video-00150-sequential-keyword-search-dog-chases-squirrel
Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/blog
Find a sequence of words in range of messy text.
Get Excel file 00150 here: http://1drv.ms/1bYwrTa
00:00 Intro
00:39 Requirement #1 Find feature & Countif
02:24 Requirement #2 intro
03:24 Requirement #2 Using Find feature
05:34 Requirement #2 Dynamic requirement description
06:07 Requirement #2 Dynamic Formula!
09:00 Requirement #2 Dynamic hyperlink!
My Post: myspreadsheetlab.com/video-00150-sequential-keyword-search-dog-chases-squirrel
Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/blog



![00169 Ankur Shuklas Solution to Debs Challenge
00:00 Ankurs Lookup & Search solution
00:39 Review of requirements
02:23 Debs solution
03:04 Step 1 search array
03:55 Step 2 1 divided by search array results
05:10 Step 3 search for a 2 (well never find)
05:35 *key concept* Binning
09:10 Step 4 [result_vector] displays answer
Original idea came from Debs Spreadsheet day challenge
Visit Debs website and youtube:
http://www.debradalgleish.com/
https://www.youtube.com/user/contextures
Heres my blog post comparing various solutions! http://www.myspreadsheetlab.com/look-for-keywords-inside-of-a-column-of-text-values/ 00169 Ankur Shuklas Solution to Debs Challenge](https://i.ytimg.com/vi/2tTZ7KDI-7M/mqdefault.jpg)






