Forum Discussion
Looking to be able to filter multiple words in a table separately
Hi, I am currently making a roster for my Esports team in excel and was just curious if there is a way to include multiple bits of information in one cell (games in this case like the top cell) and have this result - for AuB Dusty in this case - show up for each of the individual games. So for instance when filtering for "Brawlhalla" the bottom 3 show up, as well as the top "Dusty" cell.
I get that you can search under the filter, but was just curious if you can include the player will multiple options under each individual heading
- You could choose one of the text filters and select the "Contains" option and then type the item to filter for, Other than that and the Search box, you could also use VBA of course.
- Awesome thank you very much.
