Data | Filter selection |
Jan | |
Jan | |
NowJanuary | |
Feb | |
RatJan | |
Febby | |
NowFeb | |
<tbody>
</tbody>
Want to use Advanced filter whereby it filters using part supplied selection entered in the same sheet finding & filtering to all data that include this partial data
Based on example if want to filter by Jan It must filter to display
Jan
NowJanuary
RatJan
If filter selection is feb it must filter to
Feb
Febby
NowFeb
So I looking for dynamic selection option that can filer based on any part of the name that meets that criteria whatever the criteria is. It must not be case sensitive