Autofilters don't work that way. Conditions applied on separate columns are
additive (Logical AND conditions).

If you have lul set for non blanks and tl set for non blanks, then you would
only see rows where both lul and tl were non blank.

You can get what you want using an Advanced filter, but you have to specify
the critieria in a range of cells (it doesn't have to be on the same sheet.)

If you want an example, contact me with your email address and I will set up
a sample on your file and mail it to you.



--
Regards,
Tom Ogilvy


"neowok " wrote in message
...
hmm i cant get that to work.

a sample of the tables im using is
http://www.darkcity.nildram.co.uk/listtest.xls

it isnt the case on that sample but sometimes there will be something
in the lul ref column AND the tl ref column (so it needs to list it if
either column contains the typed value).


---
Message posted from http://www.ExcelForum.com/