What kind of data are you talking about? Numbers? Text? Do you have
leading or folllowing blank spaces in the data that is not showing up?

"Damo McL" wrote:

I am wondering whether any of you can help me out.

I am having a problem with the filter function in excel.

Recently some of the info I am adding to my excel sheet will not appear when
I use filters. However if I go searching for another cell in the same row it
can find them. I have sent it onto a few friends who can't figure it out
either.
Eg If I use the drop down filter look for the info in B12 it won't appear
but if I look for info in C12 then it does appear.

Now he is the other kicker. If I use the custom filter option

I have tried copying and pasting that particular column to another sheet and
it still won't work. There are no formulae in this particular column either.

I have used much bigger lists and never had this problem. Maybe if I could
e-mail it to someone who can look through it that would be great.
My head is wrecked.

Cheers
Damo