in data/filter/auto filter
 

The problem here is that if the column being sorted is more than 1000 cells
long then it does not recognise beyond line 1000.
How can I resolve this?

in data/filter/auto filter
 

"sp8" wrote in message
...
The problem here is that if the column being sorted is more than 1000
cells
long then it does not recognise beyond line 1000.
How can I resolve this?

One suggestion which I have seen is to use an additional helper column.
For example, if the data in the column is text, provide a column with the
first letter [perhaps LEFT(A1,1)?], filter by that first, then you'll
hopefully have fewer than 1000 values for your next filtering stage.
--
David Biddulph

in data/filter/auto filter
 

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 he

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

sp8 wrote:
The problem here is that if the column being sorted is more than 1000 cells
long then it does not recognise beyond line 1000.
How can I resolve this?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html