You can also use EasyFilter if you want
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"dcknie" wrote in message ...
Thanks for the help. I will set just have to set up the formula.

"dcknie" wrote:

When using auto filter on a spreadsheet that has over 1005 lines of data the
auto filter will not list any data after line 1005. What can I do to have it
list all the data?
I have a spreadsheet of names with their phone numbers that goes to line 1044.