Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello All:
I am finding out that Excel 2000 is not doing a good job with filters when it comes to cells with large amounts of text. I just wanted to see if this is others' experience as well, not me doing something wrong. Comments appreciated. Deguza |
#2
![]() |
|||
|
|||
![]()
I'm assuming youre using AutoFilter. This will only display 1000 different
entries in the drop down list, although it will filter the whole column of what can be seen. Advanced Filter is an option, Look here on Debra Dalgleish's site, she is the expert on this subject, http://www.contextures.com/xladvfilter01.html Regards, Alan. "Kompu Kid" wrote in message oups.com... Hello All: I am finding out that Excel 2000 is not doing a good job with filters when it comes to cells with large amounts of text. I just wanted to see if this is others' experience as well, not me doing something wrong. Comments appreciated. Deguza |
#3
![]() |
|||
|
|||
![]()
Thank you Alan.
My problem is not quite with the drop down list. In each cell I have large amounts of text. Such as: "Hyperion Performance Suite is the market's leading business intelligence and Enterprise reporting tool. Hyperion extends and enhances your company's investments in business intelligence software. Hyperion Performance Suite delivers a significant advancement in the scalability, reliability, and extensibility of Hyperion server products." I then look for, say, "advancement in the scalability" in a column with "custom" search within the filter. What I discovered is that the filter does not do the job. I will, however, look at the advanced filter and see if it works better. Deguza |
#4
![]() |
|||
|
|||
![]()
Debra Dalgleish has a work-around at:
http://contextures.com/xlautofilter02.html#String Kompu Kid wrote: Hello All: I am finding out that Excel 2000 is not doing a good job with filters when it comes to cells with large amounts of text. I just wanted to see if this is others' experience as well, not me doing something wrong. Comments appreciated. Deguza -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can you filter more than two items in excel 2000 | Excel Worksheet Functions | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |