| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data-auto filter not working properly?
Hi Brad
Autofilter will only show the first 1000 filtered rows. Debra Dalgleish has some workarounds on her site at http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Brad" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data-auto filter not working properly?
Obviously that's one of excels weak points. Why can't I get the "custom"
filter to work? I've done custom filters on the information that's in the drop down list and still I get nothing. "Roger Govier" wrote in message ... Hi Brad Autofilter will only show the first 1000 filtered rows. Debra Dalgleish has some workarounds on her site at http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Brad" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data-auto filter not working properly?
Hi Brad
What Custom filter are you trying to apply? What is the type of data ( a few examples) that is contained within that column? -- Regards Roger Govier "Brad" wrote in message ... Obviously that's one of excels weak points. Why can't I get the "custom" filter to work? I've done custom filters on the information that's in the drop down list and still I get nothing. "Roger Govier" wrote in message ... Hi Brad Autofilter will only show the first 1000 filtered rows. Debra Dalgleish has some workarounds on her site at http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Brad" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data-auto filter not working properly?
my dates are all dd-mmm-yy (24-Jan-07).21-Dec-01
24-Jan-07 14-Apr-03 The above are "pasted" examples. I've tried custom filters eg; "contains" Jan, *Jan* (I've also tried other months) "ends with" 07 *-07 (Ive tried other years) When I try these custom filters the filter runs and then gives me an empty screen with "0 of xxxxx records found" down below in status line and the first line of the worksheet is the first line below the last line of available information eg. "if my whole worksheet is 40325 rows long then the filtered results shows the first line at 40326 without any data. I can't scroll up any further in the worksheet until AFTER I remove the filtering information or select "All" from the drop down. (I can scroll down but not up). Thanks, Brad "Roger Govier" wrote in message ... Hi Brad What Custom filter are you trying to apply? What is the type of data ( a few examples) that is contained within that column? -- Regards Roger Govier "Brad" wrote in message ... Obviously that's one of excels weak points. Why can't I get the "custom" filter to work? I've done custom filters on the information that's in the drop down list and still I get nothing. "Roger Govier" wrote in message ... Hi Brad Autofilter will only show the first 1000 filtered rows. Debra Dalgleish has some workarounds on her site at http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Brad" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data-auto filter not working properly?
Hi Brad
The dates are all serial numbers, so they won't contain text like Jan. Today, 25 Jan 07 will be stored as 39107 and displayed as whatever format has been selected 25-Jan-07, or 25 January 2007 or 25/12/07 Try Greater than or equal 01/01/06 and Less than or equal 31/12/06 -- Regards Roger Govier "Brad" wrote in message ... my dates are all dd-mmm-yy (24-Jan-07).21-Dec-01 24-Jan-07 14-Apr-03 The above are "pasted" examples. I've tried custom filters eg; "contains" Jan, *Jan* (I've also tried other months) "ends with" 07 *-07 (Ive tried other years) When I try these custom filters the filter runs and then gives me an empty screen with "0 of xxxxx records found" down below in status line and the first line of the worksheet is the first line below the last line of available information eg. "if my whole worksheet is 40325 rows long then the filtered results shows the first line at 40326 without any data. I can't scroll up any further in the worksheet until AFTER I remove the filtering information or select "All" from the drop down. (I can scroll down but not up). Thanks, Brad "Roger Govier" wrote in message ... Hi Brad What Custom filter are you trying to apply? What is the type of data ( a few examples) that is contained within that column? -- Regards Roger Govier "Brad" wrote in message ... Obviously that's one of excels weak points. Why can't I get the "custom" filter to work? I've done custom filters on the information that's in the drop down list and still I get nothing. "Roger Govier" wrote in message ... Hi Brad Autofilter will only show the first 1000 filtered rows. Debra Dalgleish has some workarounds on her site at http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Brad" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data-auto filter not working properly?
Roger,
I was experimenting and it seems strange, I can ask for the opposite of what I want "does not "end with or contain" and it will return with the whole worksheet 50307 of 50307 records found but if I do an "ends with" or "contains" I don't get any data 0 of 50307 records found. Regards, Brad "Roger Govier" wrote in message ... Hi Brad What Custom filter are you trying to apply? What is the type of data ( a few examples) that is contained within that column? -- Regards Roger Govier "Brad" wrote in message ... Obviously that's one of excels weak points. Why can't I get the "custom" filter to work? I've done custom filters on the information that's in the drop down list and still I get nothing. "Roger Govier" wrote in message ... Hi Brad Autofilter will only show the first 1000 filtered rows. Debra Dalgleish has some workarounds on her site at http://www.contextures.com/xlautofilter02.html#Limits -- Regards Roger Govier "Brad" wrote in message ... 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 |
| Reply |
| 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) | |||
Hybrid Mode
