Excel functions to search for text within cells
Wildcard Characters tutorial: • Excel Wildcard Characters | Tutorial ...
Excel Tables tutorial: • Excel Tables | Why you MUST put your ...
Excel Interactive Dashboard tutorials (Parts 1 & 2):
• Interactive & Dynamic Dashboard in Ex...
• Dynamic Chart Ranges in Excel | Inter...
Download the tutorial file: https://github.com/alexsington/Data-S...
This tutorials covers how to create new table columns based on subtext (text within text) searches. This includes the SEARCH function, the FIND function, and the COUNTIFS function with wildcard characters. You can use these new columns to help you filter your data with the FILTER function.
0:00: Problem
0:54: Wildcard characters
2:12: SEARCH function
3:55: FIND function
5:24: Filtering data
7:02: Interactive dashboard filtering