I have a list that sort though anime, tags, and my ratings for them.
i have three box that i want to act as a search box. when i type in a genre (F1) i want it to show the ones contain the tag and also correspond it to a rating i put in two cells (H1) later and exclude any line that contains the contains of J2. it has to treat all three as a sub-string. i've kept trying to figure out the auto-filter commands. on a different doc i was able to hide and unhide sheet when specific words were typed into a cell, i tried to relate it here to no avail