Problem with filtering an Excel Spreadsheet
Thread poster: Klaus Urban

Klaus Urban  Identity Verified
Local time: 04:07
Member (2005)
English to German
+ ...
Jan 10, 2010

I am quite familiar with the filter function using a Excel spreadsheet. This time, however, I´m lost. The spreadsheet I am currently working with is quite comprehensive, 1300 rows and columns A-AN, has been put together over years.
When filtering by name, the drop down menue shows names A-Sti, names Sto-Z do not show up in the filter drop down menue.
I could not find a reason for this. There is no blank row after Sti.
Has anyone an idea what could be the reason for this problem?
Thank you for any help.
Best regards
Klaus


 

RieM  Identity Verified
United States
Local time: 22:07
English to Japanese
+ ...
This page may help you.. Jan 10, 2010

Hi Klaus,

If you are using a pre-2007 version, there is a limit -- 1000 entries - on the number of unique entries that appear in the dropdown. This page explains that:

http://excel.tips.net/Pages/T002403_Increasing_the_AutoFilter_DropDown_Limit.html

There are a number of discussions and suggestions over the Internet about how to deal with this. Hope you will find what best suits your case!

Regards,
Rie


 

Klaus Urban  Identity Verified
Local time: 04:07
Member (2005)
English to German
+ ...
TOPIC STARTER
@ Rie Jan 10, 2010

Thank you Rie, this really explains the situation I am faced with. I need no longer try to find out what my be wrong with my Exceel sheet.
Thank you also for the link. I will try the tip to reduce the number of unique entries.
Best regards
Klaus


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Problem with filtering an Excel Spreadsheet

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search