I have a medium sized spreadsheet (12 col, 3000 rows) and I have activated
the autofilters across the 12 columns. The sheet is pre-sorted by the first
col which contains text and no filters are set. In seeking a number in the
third column I use the drop list expecting to find a complete listing of all
the numbers in the column however, the number I seek does not appear yet I
know it exists.
Then when I use the Filter and sort the 3 column ascending the number along
with many others magically appear in the drop list. Is there a known issue
using autofilters or a perhaps a limitation in the drop lists???
--
Thank you