Thanks for the reply, JennD. I think that Excel 12 will remove that
limitation. Please see Paul B's response for some workarounds.
--
Sincerely, Michael Colvin


"JennD" wrote:

Thanks Michael. I sure did find out . . . the hard way.
I thank you for your response, I had no idea that there was a 1000 limit on
the filter.
What doesn't kill you makes you stronger, right!!

"Michael" wrote:

Hi JennD. I'm sorry to say that auto filtering a single column is limited as
you have found out. Perhaps you could split the single column into two or
more for filtering purposes.
--
Sincerely, Michael Colvin


"JennD" wrote:

Does anyone know of a limit of 1000 unique records when using an autofilter?
I have a worksheet with over 12,000 records of duplicate IDs that have to be
filtered to find bonus qualifiers and last month I had 1097 unique IDs that
needed to be filtered and processed. When using the filter to search for the
IDs it would stop at the 1000th ID and not show me the IDs beyond that at
all. I could only get to them by scrolling to the bottom, but I really need
to filter these to find out if all the criteria is met for the bonus.
Needless to say, we missed 97 unique IDs that could nave been paid out as
bonuses last month and I would like to find out how this could have happened.
Please help if you can.