One way would be to use a helper column and then have an IF statement or
perhaps a VLOOKUP, that returned a value such as "Show" or "Hide" based on
whatever criteria you want to set. You can then just use Data / Filter /
Autofilter to show just the "Show"s