Excel List Function

  • Thread starter Thread starter TC Ong
  • Start date Start date
T

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
 
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 **
 
Back
Top