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.