Re: Limit of records when using auto filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

http://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 & 2003

"JennD" <JennD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B17BEC9-C811-4AAC-AAC1-65B1B03D9919@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • RE: IDS event filtering
    ... I think there are a few ways to filter; ... at in over a year so not sure if any backend IDS correlation. ... Deprioritize alerts on ... > Find out quickly and easily by testing it with real-world attacks ...
    (Focus-IDS)
  • Re: IDS event filtering
    ... I won't filter out anything. ... does not guarantee anything (e.g. you know you do not have MSSQL ... > ingress - egress firewall rules, IDS configs, or whatever. ... > IDS sensors. ...
    (Focus-IDS)
  • Cisco IDS 4210 Follow-up questions
    ... A few weeks ago I posted asking for documentation links on the IDS ... want to exclude it for the destination and source IPs I am seeing. ... If I do a filter and put a subSigID in and teh same settings as above ...
    (comp.dcom.sys.cisco)
  • Re: IDS event filtering
    ... > I am wanting to get an idea of what you guys out there filter from your ... > IDS sensors. ... Some of the sensors I monitor get TONS of events for MSSQL ... > have any SQL services on the internet, is it safe to filter out those ...
    (Focus-IDS)
  • Re: Limit of records when using auto filter
    ... You could still filter using custom--it's just that the dropdown is limited to ... 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 ...
    (microsoft.public.excel.misc)