How many entries can Excel handle!?
in [General]
|
Prev: Function to determine if a cell contains a formula
Next: How can I test for nulls within a range without specifying eac
From: Dave Peterson on 25 Mar 2010 22:29 xl2003 and below will only show 1000 unique entries in the autofilter dropdown. But you can use a custom filter and type in what you're looking for (use contains???). Rebecca Sage wrote: > > I have close to 1000 entries in my Excel spreadsheet, and am trying to figure > out why entries are coming up missing. I often do custom sorts. This may be > when entries get tossed out? -- Dave Peterson
From: JLatham on 25 Mar 2010 22:36 You may have hit on it - perhaps she meant custom filtering rather than custom sorting. "Bob I" wrote: > 1000? that is a filter limit for unique items. > > Rebecca Sage wrote: > > > I have close to 1000 entries in my Excel spreadsheet, and am trying to figure > > out why entries are coming up missing. I often do custom sorts. This may be > > when entries get tossed out? > > . >
From: "David Biddulph" groups [at] on 26 Mar 2010 03:22
If that's the problem, try the advice at http://www.contextures.com/xlautofilter02.html#Limits -- David Biddulph "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message news:4BAC1C25.2EFCE0C0(a)verizonXSPAM.net... > xl2003 and below will only show 1000 unique entries in the autofilter > dropdown. > > But you can use a custom filter and type in what you're looking for (use > contains???). > > Rebecca Sage wrote: >> >> I have close to 1000 entries in my Excel spreadsheet, and am trying to >> figure >> out why entries are coming up missing. I often do custom sorts. This may >> be >> when entries get tossed out? > > -- > > Dave Peterson |