Removing rows in which 1 cell's value appears on a separate list
I have a table about 20 columns wide and a few hundred rows. One column has
a 4 letter code (which there are about 100 unique values for). There are
lots of duplicates, but I'm not concerned about those. What I want to do is
remove (or even just highlight) rows where that the 4-letter code is one that
shows up on a separate list of about 20 such codes.
Thanks!
|