View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
creativeops creativeops is offline
external usenet poster
 
Posts: 17
Default 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!