Hi, please help me if possible. Say i have data from "A5:Z500", i want to check for all that the rows that contain a "yes" in column Z, and then delete those rows which contain a "Yes". Values with a blank or "No" must just be left alone.

Please help. thank you