I'm trying to streamline a job I have, and I'm not entirely sure how to. I'm excel dumb, but this is what I'm trying to do
4 columns A, B, C, and D. I'm worried about B and D. I want to check B for certain words, and check if there's any value in D. If B contains anything other than my designated words and D contains nothing.. I want to delete the entire row.
IE B1, b2, b3, b4 and b5 all says respectively Dog one, dog one, dog two, dog two and dog three... I want to search B for the words "one and three" if they contain either/or they're safe regardless of what's in D. For every entry that does not contain "one" or "three" in B, I want to check D. if D is blank. I want to delete that entire row.
IF I'm not making sense I can try to clarify a little better. I'll be checking daily to see if this ends up answered. Thank you in advance.
edit: I can't install any programs or third party deals on this computer. I'm not sure if that's a problem, but I read somewhere that some scripts required outside programs. I want to streamline this to all be done within excel