Filter Limitations

[Lisa928]

Does anyone know what the limit is for the filter drop down box? I have a list of products (sorted alphabetical) and the filter only shows products starting with A-D. Is the limit by the lines it searches to pull the unique occurrences, or is it by the number out output lines in the drop down?

Thanks in advance!
This message was edited by Lisa928 on 2002-10-10 11:49

 

[Mark W.]

On 2002-10-10 12:50, Tom@CPC wrote:
Thanks for pointing that out Mark, if you select the columns for the table this will alleviate that issue. Not to many people understand this method of selection though. I find it extremely useful in setting the datarange for my pivottables when the raw data is retrieved from an external database. This makes the range for data dynamic.

I was refering to the situations where a user is just in a cell in the table and selects auto filter.

Yes, ...and, in that case your observation/concern is well justified.

 

[Tom Urtis]

Hi Mark --

I've wondered about that 999 vs 1000 thing, I looked it up in a couple books just now, and two books I could find it in (both by J-Walk, Bible & Formulas) specifically state 999, so at least my recollection was correct.

This is easy to test, by filling 1 - 1000 and autofiltering by the header, which I did, and yes you and Juan are absolutely correct. Thanks for pointing that out. Reminds me to practice the saying: "Trust and verify".

Thanks again.

 

[Mark W.]

Are you a Reaganite?

 

[Lisa928]

Hi everyone, thanks for the responseS! Sorry to stir up so much controversy.

 

[Mark W.]

On 2002-10-10 13:03, Lisa928 wrote:
Hi everyone, thanks for the responseS! Sorry to stir up so much controversy.

Don't be sorry... We love to match wits around here