Autofilter Lists Problem

I have a spreadsheet that has 1576 rows and 30 columns. When doing spot
checks I switch on the Autofiler and use the drop down list to locate the
specified value. In my spreadsheet in one column that I have labelled as
"Lot" I am unable to locate the specified value. However, I can scroll down
and see the value or I can use the CTRL+F function to find the value.

So why am I unable to see the value through the AUTOFILTER drop down list
when all rows are selected.

This has become very frustrating so any help and advice would be great. I
am unable to use the AUTOFILTER dropdown list anymore because I can't trust
the results.

Autofilter will only display 1000 seperate items. One way round it is to use
another adjacent column with sub categories and filter by that column, then
the original to keep under 1000 seperate items,
Regards,
Alan.
"Medows" <Medows@discussions.microsoft.com> wrote in message
news:3AD7607E-9C6F-412E-9D75-46A2E12F3672@microsoft.com...
>I have a spreadsheet that has 1576 rows and 30 columns. When doing spot
> checks I switch on the Autofiler and use the drop down list to locate the
> specified value. In my spreadsheet in one column that I have labelled as
> "Lot" I am unable to locate the specified value. However, I can scroll
> down
> and see the value or I can use the CTRL+F function to find the value.
>
> So why am I unable to see the value through the AUTOFILTER drop down list
> when all rows are selected.
>
> This has become very frustrating so any help and advice would be great. I
> am unable to use the AUTOFILTER dropdown list anymore because I can't
> trust
> the results.
>

An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't
all be displayed in the dropdown list.


To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the dropdown list, and type the criteria. Also,
there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html#Limits

Medows wrote:
> I have a spreadsheet that has 1576 rows and 30 columns. When doing spot
> checks I switch on the Autofiler and use the drop down list to locate the
> specified value. In my spreadsheet in one column that I have labelled as
> "Lot" I am unable to locate the specified value. However, I can scroll down
> and see the value or I can use the CTRL+F function to find the value.
>
> So why am I unable to see the value through the AUTOFILTER drop down list
> when all rows are selected.
>
> This has become very frustrating so any help and advice would be great. I
> am unable to use the AUTOFILTER dropdown list anymore because I can't trust
> the results.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html