Hi Greg, I can't get this working.

When I choose custom, I then specify in the top line 'Contains' and the
value '0000'. This should only show rows that contain 0000, however it
filters out all rows, e.g. nothing appears.

Any ideas how to just show rows that have 0000 in the column I am
customising the filter for?
--
Thanks.

CJSnet

(Remove TEETH to reply by e-mail.)


"greg7468" wrote in
message ...

Hi,
click on the header of the column with the data you want to filter (the
one with the 0000 in)
Go to Data Filter Autofilter

Now click on the dropdown arrow in the header and choose custom

From there you have several options to filter for data you want or
filter out data you do not.

If you filter the data to show what you do not want, you can then
delete those rows.

HTH,

Greg.


--
greg7468
------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=374220