Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find multiple items?
I have very large spreadsheets with 10s of thousands of items, all with
unique identifiers. I then get a small subset of those identifiers and have to pull full info from the huge sheet for each identifier. Performing a "find" for every item is far too time consuming. Does anyone know how I can take a small subset of identifiers and find them all at once on the larger sheet? Thanks for any help you can provide!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find multiple items?
It kind of sounds like Data|filter|Advanced filter would do what you want:
http://contextures.com/xladvfilter02.html (From Debra Dalgleish's site) JahFe wrote: I have very large spreadsheets with 10s of thousands of items, all with unique identifiers. I then get a small subset of those identifiers and have to pull full info from the huge sheet for each identifier. Performing a "find" for every item is far too time consuming. Does anyone know how I can take a small subset of identifiers and find them all at once on the larger sheet? Thanks for any help you can provide!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicates between multiple XLS files | Excel Discussion (Misc queries) | |||
How to group multiple items in to three groups. | Excel Worksheet Functions | |||
How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
Can VLookup function find and list multiple records? | Excel Worksheet Functions | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |