software

Hi,

If I have lets say 3000 rows and 4 columns and If I want to use
Auto-filter on one column then the list of unique entries which
Auto-filter window offers is not complete. I see that this behaviour
happens when number of rows is quot;largequot;.

Has anybody else experienced this problem?

(I know that one can use advanced filter by using criteria list, but
sometimes auto-fiter is quot;quickerquot; for some mundane tasks. Also, I
understand that in excel keeping so many rows is not good,but would
like to ignore it for the moment.)

Regards,
Hari
IndiaHi Hari,

See Debra Dalgleish's Autofilter limits page at:

www.contextures.com/xlautofilter02.html#Limits---
Regards,
Normanquot;Hariquot; gt; wrote in message oups.com...
gt; Hi,
gt;
gt; If I have lets say 3000 rows and 4 columns and If I want to use
gt; Auto-filter on one column then the list of unique entries which
gt; Auto-filter window offers is not complete. I see that this behaviour
gt; happens when number of rows is quot;largequot;.
gt;
gt; Has anybody else experienced this problem?
gt;
gt; (I know that one can use advanced filter by using criteria list, but
gt; sometimes auto-fiter is quot;quickerquot; for some mundane tasks. Also, I
gt; understand that in excel keeping so many rows is not good,but would
gt; like to ignore it for the moment.)
gt;
gt; Regards,
gt; Hari
gt; India
gt;
Hi Hari

See
www.contextures.com/xlautofilter02.html#Limits

If you filter on one column you can use this add-in
www.rondebruin.nl/easyfilter.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;Hariquot; gt; wrote in message oups.com...
gt; Hi,
gt;
gt; If I have lets say 3000 rows and 4 columns and If I want to use
gt; Auto-filter on one column then the list of unique entries which
gt; Auto-filter window offers is not complete. I see that this behaviour
gt; happens when number of rows is quot;largequot;.
gt;
gt; Has anybody else experienced this problem?
gt;
gt; (I know that one can use advanced filter by using criteria list, but
gt; sometimes auto-fiter is quot;quickerquot; for some mundane tasks. Also, I
gt; understand that in excel keeping so many rows is not good,but would
gt; like to ignore it for the moment.)
gt;
gt; Regards,
gt; Hari
gt; India
gt;
Norman and Ron,

Thanks a lot for link to Debra's site. I had been there some months
back but must have missed this crucial point regarding limit.

Ron - Thanks for Easy filter. It would be very helpful to me.

regards,
Hari
India