delete/filter specific names terminations rows

[rosamoreno]

Hello

I would like to delete a specific rows which contain certain names or termination names.

This is what i have:
photo 1.PNG


and this is what i'd like to have:

photo 2.PNG

as you can see i'd like to delete for exemple all names that have the name 'amide' but also names that have 'amine' termination etc... so i'd like to delete the rows + the UTI and REF for each.

Its basically filtering names and deleting them with their respective informaiton.


Thank you i hope it was clear.

please find attached the excel file