Filter more than 1000 unique records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I want to use the auto filter option for a worksheet that contains atleast 40,000 records of which there are approximately 10,000 unique records. It seems that filter only takes the first 1,000 unique records and ignores the rest.

Will be grateful if anyone can show how to workaround this. I am using excel 2002.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering for Unique Records with multiple-column criteria 5
Filter (blanks) with two or more unique values not working 1
AutoFilter only filtering first 1000 2
Limit of records when using auto filter 5
filtering for unique records 7
Unique Records Filter-Updating new entries 1
Auto filter : Only the first 1000 unique entries in a list appear. 1
how get i see above 1000 date in auto filter? 1

Back
Top