Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out data
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 ;) "BABYPINK" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out data
Hi BABYPINK
Is all the information in one cell ? Or is RAL9001 in a seperate cell -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BABYPINK" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out data
Maybe you could use DataFilterAutofilterCustomContains RAL
Gord Dibben MS Excel MVP On Wed, 17 Oct 2007 08:20:01 -0700, BABYPINK wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering data | Excel Worksheet Functions | |||
Filtering Data | Excel Discussion (Misc queries) | |||
filtering data | New Users to Excel | |||
Filtering out Data | Excel Discussion (Misc queries) | |||
Filtering data | New Users to Excel |