I have a list of data that includes ID numbers with combinations of numbers
and letters and dashes. In an older version of Excel I was able to use
autofilter to filter the rows by ID number...However, when I turn on
autofilter with the cellsof the ID column selected, I do not get a complete
list of ID by which to filter, it only shows me the items hat have ID's that
are just numbers. Any help would be greatly appreciated.