About Us

yogesh kumar

Email ID:

When you use the AutoFilter command in Microsoft Excel, the AutoFilter
list may not display all the unique visible items in a column as
expected. the limitation of the amount of entries in the AutoFilter list
is 1,000. If you have more than 1,000 unique items in the list, only the
first 1,000 items appear.

There is no way to increase this limit in the current versions of Excel;
it is hard-wired. If you want to do more complex filtering, you will
need to use the advanced filtering tools in Excel. (They aren't that
hard to use, and can provide some very interesting ways of examining
your data.)

If you prefer to use AutoFilter, you might look at how your data is
organized in your table. For instance, let's say you have a huge list of
customer transactions, and you want to filter the data by customer name.
The trouble is, you have more than 1,000 unique customers, so you can't
see all the customer names in the AutoFilter drop-down list.

The solution is to add another column, perhaps just to the left of your
customer name column. Use a formula in the column that pulls out the
first letter of the customer's last name. You now have a list of single
alphabetic letters. It is much easier to AutoFilter on this column; all
26 letters appear quite nicely in the drop-down list. Select a letter,
and this filters your data so that only those customers whose last names
begin with that letter are displayed. You can then use the drop-down
list in the customer name column to select from all the customers in the
pared-down list.

- Yogesh

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Menu

About Us