The Autofilter misses some numbers

D

DaleH

Hi all,

I have a spreadsheet that has a lot of different ID numbers on it
which repeat in various places down the column.

I put on the autofilter so I can click the drop down and select
whatever ID number I want and it displays all the entries with that ID
number grouped together.

That works great but it leaves out some of the ID numbers. I've
re-created the spreadsheet, put the column in a text file and imported
etc but it still leaves out some of the numbers. Any ideas, this is
driving me nuts :eek:


Dale
 
H

Heather Heritage

you probably have blank lines in the data - which Excel interprets as end of
data. Solution is to select as a range the entire block of data, then apply
the autofilter.
 
D

David Biddulph

DaleH said:
You can only use 1000 unique records for the auto filter to work

Thanks

Dale
Click to expand...

The autofilter will work, but it won't present the extra items in the
drop-down menu.
One recommended work-round is a helper column to sub-divide the original
list (such as 0-1000, 1000-2000, etc.), filter on that first, and then
fine-tune from there.
 
C

CarlosAntenna

I had a user with a similar complaint recently.

Make sure there are no hidden rows within your data range. Select the
entire sheet by clicking on the blank rectangle above row 1 and left of
column A, then click: format > row > unhide.
 
Top