"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