Hi Keith,

Because you have your data in a table, have you tried AutoFilter? Also the "Advanced Filter" function of Excel may also do what you're looking for. I'm a pivot table advocate and believe they would also do what you want.

Posting an example file is the best way for us to help if the suggestion doesn't make sense.
AND - welcome to the forum!!