Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find multiple items on a sheet??
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 to 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!! -- JahFe ------------------------------------------------------------------------ JahFe's Profile: http://www.excelforum.com/member.php...o&userid=31373 View this thread: http://www.excelforum.com/showthread...hreadid=510650 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find multiple items on a sheet??
You have one response at your earlier post.
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 to 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!! -- JahFe ------------------------------------------------------------------------ JahFe's Profile: http://www.excelforum.com/member.php...o&userid=31373 View this thread: http://www.excelforum.com/showthread...hreadid=510650 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build a single order sheet from a multiple page material list. | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
drag multiple data items into pivot | Excel Worksheet Functions | |||
printing multiple sheet tabs to image file | Excel Discussion (Misc queries) | |||
Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions |