How to print the drop down menue when filtering an Excel sheet
Thread poster: Klaus Urban

Klaus Urban  Identity Verified
Local time: 23:42
Member (2005)
English to German
+ ...
Aug 23, 2009

In connection with my various translations of English rose books into German, I have compiled a very comprehensice data base of rose names and synonyms, currently 25,000 entries. Printing out would result in 500 pages.
Filtering the column "breeder" shows a drop down menue of breeders in alphabetical order. Can I print this alphabetical list (800-1000 names, approx. 20-25 pages)?
I need this to cross check against a separate data base of breeders.
Any help will be most welcome.
Klaus


Direct link Reply with quote
 

Harry Bornemann  Identity Verified
Mexico
English to German
+ ...
Copy to Access Aug 23, 2009

I would copy the column "breeder" into an empty Access table (or open the Excel file in Access) and then apply a simple grouping query, with sorting.
Harry


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 23:42
English to Czech
+ ...
Filter unique records Aug 23, 2009

Use Advanced filter in Excel, here is how:
http://www.contextures.com/xladvfilter01.html#FilterUR


Direct link Reply with quote
 


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


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

How to print the drop down menue when filtering an Excel sheet

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 »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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