software

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.

JennD, that is correct, have a look here for details and a workaround

www.contextures.com/xlautofilter02.html--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

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

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

You could still filter using custom--it's just that the dropdown is limited to
1000 unique entries.

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

--

Dave Peterson

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!!

quot;Michaelquot; wrote:

gt; Hi JennD. I'm sorry to say that auto filtering a single column is limited as
gt; you have found out. Perhaps you could split the single column into two or
gt; more for filtering purposes.
gt; --
gt; Sincerely, Michael Colvin
gt;
gt;
gt; quot;JennDquot; wrote:
gt;
gt; gt; Does anyone know of a limit of 1000 unique records when using an autofilter?
gt; gt; I have a worksheet with over 12,000 records of duplicate IDs that have to be
gt; gt; filtered to find bonus qualifiers and last month I had 1097 unique IDs that
gt; gt; needed to be filtered and processed. When using the filter to search for the
gt; gt; IDs it would stop at the 1000th ID and not show me the IDs beyond that at
gt; gt; all. I could only get to them by scrolling to the bottom, but I really need
gt; gt; to filter these to find out if all the criteria is met for the bonus.
gt; gt; Needless to say, we missed 97 unique IDs that could nave been paid out as
gt; gt; bonuses last month and I would like to find out how this could have happened.
gt; gt; Please help if you can.

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 Colvinquot;JennDquot; wrote:

gt; Thanks Michael. I sure did find out . . . the hard way.
gt; I thank you for your response, I had no idea that there was a 1000 limit on
gt; the filter.
gt; What doesn't kill you makes you stronger, right!!
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; Hi JennD. I'm sorry to say that auto filtering a single column is limited as
gt; gt; you have found out. Perhaps you could split the single column into two or
gt; gt; more for filtering purposes.
gt; gt; --
gt; gt; Sincerely, Michael Colvin
gt; gt;
gt; gt;
gt; gt; quot;JennDquot; wrote:
gt; gt;
gt; gt; gt; Does anyone know of a limit of 1000 unique records when using an autofilter?
gt; gt; gt; I have a worksheet with over 12,000 records of duplicate IDs that have to be
gt; gt; gt; filtered to find bonus qualifiers and last month I had 1097 unique IDs that
gt; gt; gt; needed to be filtered and processed. When using the filter to search for the
gt; gt; gt; IDs it would stop at the 1000th ID and not show me the IDs beyond that at
gt; gt; gt; all. I could only get to them by scrolling to the bottom, but I really need
gt; gt; gt; to filter these to find out if all the criteria is met for the bonus.
gt; gt; gt; Needless to say, we missed 97 unique IDs that could nave been paid out as
gt; gt; gt; bonuses last month and I would like to find out how this could have happened.
gt; gt; gt; Please help if you can.