Strange autofilter problem

[Gordon]

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

 

[Max]

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

 

[gordon]

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

Yes they do. I wasn't aware of this limit! Thanks

 

[Max]

You're welcome !