Download Excel File: https://excelisfun.net/files/EMT1663.xlsx
Learn how to extract matching items from a cell and display horizontally. See Office 365 Formulas, and Old School Formulas. See Conditional Formatting too. 5 Awesome examples where you can learn about the following functions: FILTER, TRANSPOSE, SEARCH, ISNUMBER, INDEX, ROWS, IF, COUNTA, COLUMNS, AGGREGATE, LET and much more!
Topics:
1. (00:01) Introduction
2. (00:18) Create Defined Name.
3. (00:28) Office 365 Formula with the functions: FILTER, TRANSPOSE, SEARCH, ISNUMBER. This is a Spilled Array Formula.
4. (02:45) Formula for Dynamic Label with the Functions: IF, COUNTA, COLUMNS. Bonus #1
5. (03:43) Conditional Formula for Spilled Array. Bonus #2.
6. (04:41) Old School Array Formula with the functions: IF, COLUMNS, COUNT, SEARCH, INDEX, AGGREGATE, ROW, ISNUMBER. Bonus #3
7. (05:16) Office 365 Formula with the functions: LET, FILTER, TRANSPOSE, SEARCH, ISNUMBER. This is a Spilled Array Formula.
8. (06:10) Summary and End Video Links

Extract Matching Items From Cell and Display Horizontally. SEARCH Results Spilled Horizontal. Extract Text From Cell.