Extracting certain rows based on multiple criteria

Greetings.

I really hope that this forum can help me out. There is no where else for me to go.
My problem is: I have a table with over 30,000 rows and columns A - W.
The first column A contains UNIQUE ID.
Column G contains CATEGORY CODE.

Example.png


Since Unique ID (column A) can be listed more than ones, I need to select only those records (rows) that correspond to the following:
Category Code (column G) is either 14, 15, 16, 17, 18 and not any other. I hope you can see the attachment, UNIQUE ID = a;does not satisfy my criteria as it does contain Category Code 14, it also contain other codes.
The final result from the sample provided would be extracting data for UNIQUE ID = e (since it is the only record that does not contain any values other than 14, 15, 16, 17, 18).

Not sure if it could be done without VBA, but, any help would be greatly appreciated.

Thank you.

See attachment
First Filter on Column D and select Qualify, then filter on column G and select True.

You will get desire records.

Vinay

Hi Nurik,

Mark this post SOLVED if you got your answer!

Thank you so very much for your help.

I have not checked the solution, and therefore did not want to get this post updated. But, I am pretty sure that it will do the trick.