#1
|
|||
|
|||
Get all rows based on input values from a list
I have one spreadsheet with approx 50000 rows. It contains 24 columns with column A (Name) as a key column. However with multiple occurrences. I have a list of names, and for each name I want to list all the occurrences (with all 24 columns) in my spreadsheet based on the value in column A. I can to this one by one name from my input list by manually using the 'Search' and 'Textfilter Equal to' in my spreadsheet.
However I want to perform my search using the whole list in one go, and not one by one name. Is it possible? Will I have to use the vlookup function? Or another way to handle this? |
#2
|
||||
|
||||
What you're describing is the kind of thing one might use a Word mailmerge for; in particular, a directory merge with grouping. To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial or: http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. Mailmerges allow you to filter by all the names of interest An alternative is to copy, then sort the data in Excel, then delete the unwanted rows.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
Insert values from multiple rows based on value in one column | pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |
Inserting text from one word file into another based on an excel input | jmaxcy | Excel | 14 | 11-01-2013 04:07 PM |
Look up an array based on user input | johnsmb | Excel | 2 | 01-07-2011 01:12 PM |