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.