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!! |
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 |
All times are GMT +1. The time now is 08:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com