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