Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter Problems
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter Problems
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter Problems
Its text. Namely address's. A friend of mine gave me the answer. Filter lists can only have 1000 unique pieces of data in it. So I have to split the list. Its every frustrating. Looks like I'll be moving to access for this. Excel just doesn't have enough capabilities for data storage "tim m" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter problems | Excel Discussion (Misc queries) | |||
Auto Filter problems... | Excel Worksheet Functions | |||
Excel 2000 filter problems | Excel Worksheet Functions | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Advanced Filter Problems | Excel Discussion (Misc queries) |