Mr Excel & excelisfun Trick 98: Extract & Lookup Number When Table Of Numbers Is In A Single Cell
4,385 views · Published 17 February 2012 · 8:08 · Indexed 30 September 2026
Channel: excelisfun · 2012 · Education
Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick98.xlsx Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Mr Excel and excelisfun use two methods to: 1. Check whether Numbers In Cell C2 Also In F2? 2. Mr Excel does VBA solution 3. Excelisfun does Formulas Solution. See how to increment the numbers 1, 4, 7,... with ROWS Function; extract Characters from a cell with MID function.; use MID function and array constant to create a lookup table from data in a single cell; Use MATCH and ISNUMBER functions to check whether or not numbers in cell C2 are also in F2.
More from this channel
-
3:51
YouTubersLoveExcel#19: Steady Growth Cash Flow Formula
-
1:39
YTLE#60: Hide Columns by Grouping
-
8:18
YTLE#80: Conditional Format MATCH & INSUMBER functions
-
4:16
YTLE#82: Enter UPPER Case Text Only Into The Cell
-
3:22
YTLE#93: "Go To Special Blanks" Caveat
-
6:24
YTLE#104: Find 1st Positive# in Excel List
-
4:50
YTL Excel #123: Array Formula To Count E-mails
-
0:03
Family At Christmas Tree