View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BABYPINK BABYPINK is offline
external usenet poster
 
Posts: 3
Default Filtering out data

Hi

I have a smallish table that lists Parts, and I only want to list the parts
that have RAL9007, RAL9005, RAL9006, each row looks something like this with
various combinations

ADJ SNACK FLANGLE SHELF 400MMDEEP 1250MM CREAM RAL9001 +SEL

I have 16,000 rows of these and it will take me ages to delete the rows out
I do not want, any idea what formula I would need

Thanks