Excel List Function

[TC Ong]

Hi,

I have a column of data upto 22,600 lines. I use the
create list function and tried the autofilter function too.

However, the list is NOT complete. It list the data upto
row 14215 ONLY.

Can anyone help me?

Thank You.
TC Ong

 

[Paul B]

Autofilter will show only the first 1000 unique items, have a look here for
some work arounds

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 2000 & 97
** remove news from my email address to reply by email **