Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel AutoFilter Problem | Excel Discussion (Misc queries) | |||
Strange Excel problem when opening an Excelbook | Excel Discussion (Misc queries) | |||
autofilter problem | Excel Worksheet Functions | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |