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.