Strange autofilter problem
 

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

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

Max wrote:
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

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--