I have a dataset where I need to see if a particular row contains 4 conditions, like the following:
2/1/2016 EB 112 D13A
2/1/2016 EB 112 D24A
2/1/2016 EB 112 F24A
2/1/2016 EB 112 F24B
2/1/2016 EB 112 H13A
2/1/2016 EB 112 H24A
2/1/2016 EB 122 B13A
2/1/2016 EB 122 D24A
2/1/2016 EB 122 D24B
6/1/2016 EB 112 2C0A
6/1/2016 EB 112 6C0A
So if a row in my data contains a certain date, a certain two letter code, a certain three digit number, and a certain 4 digit code, I indicate "yes" or "no. I think I can do this with IF, AND, and OR together, or use MATCH with 4 conditions per row, but I have 50 rows of 4 conditions. Is there an easier way? Thank you.
Bookmarks