Perhaps the unique invoice numbers under "Invoice Ref "column
exceed the limit of 1,000 in autofilter's droplist ?

This limit is mentioned in Debra's page:
http://www.contextures.com/xlautofilter02.html#Limits
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Gordon" wrote in message
...
I have a file which is an exported list of unpaid invoices from Sage
Accounting system.
I select the column "Invoice Ref" and turn on Autofilter. The Invoice I am
looking for is NOT in the drop-down list.
However, if I turn on autofilter for the Date column, and select the date
on
which this Invoice was posted, there, in the Invoice Ref column, is this
invoice number. Can anyone please suggest a reason why this Invoice number
does NOT appear when I autofilter the "Invoice Ref "column?

Thanks