Filtering out data

[Guest]

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

 

[Guest]

Hi babypink,

best thing i can think of is using a filter. selet the header row then go to
data --> filter --> auto filter.

this will put a drop down box in the cells in the header row. Click on the
down arrow in the parts column and click on "(custom...)". Unfortunately
there are only 2 conditions you can do at once, so you might want to go one
part (RAL9007) at a time.

Select contains from the first drop down box, then enter RAL9007 into the
textbox, then OK. This will filter all the part descriptions that include
RAL9007.

Good luck,

stevefromnaki

 

[Ron de Bruin]

Hi BABYPINK

Is all the information in one cell ?
Or is RAL9001 in a seperate cell

 

[Gord Dibben]

Maybe you could use Data>Filter>Autofilter>Custom>Contains RAL


Gord Dibben MS Excel MVP