| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data-auto filter not working properly?
I've got a worksheet that has a column of dates (eg. 24-Jan-07) they are
different days, different months and different years with some repeating.There are over 47000 rows so I have a lot of data. I am trying to auto-filter this column but when I click on the down arrow it doesn't list ALL of the possible dates that are available. Also, when I do a "custom" filter for information I know is there (eg. ends with "07") it doesn't pull any information at all yet the worksheet page shows it's located at the first row below the last available row of data (eg. I have 47802 rows it says it's at row 47803 after running the custom filter) I can't scroll up to view any rows above that line until I undo the "auto filter" settings I've chosen (puzzled on that). It appears my "data-auto filter" and /or "custom filtering" isn't working properly. Is there a know issue with this? I've never had this problem before. Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement for time data not working properly | Excel Worksheet Functions | |||
| Why do I not see all my data when I use the auto filter drop down | Excel Discussion (Misc queries) | |||
| auto filter not working on all data | Excel Worksheet Functions | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
| Auto Filter not working properly | Excel Discussion (Misc queries) | |||
Threaded Mode
