| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
searching a large database with a long list of search terms
Max,
The OP didn't get back to me when I asked about sorting the reference data beforehand. Can you sort your random data in the 6 sheets then re-apply your formula to take advantage of this to see if there is a big increase in speed? In theory, the binary search technique applied if the data is sorted should make a massive difference to 6 * 65536 entries. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two search category & two search terms | Excel Discussion (Misc queries) | |||
| Searching long data base list. | Excel Worksheet Functions | |||
| Search for a specific entry in a long data validation list | Excel Discussion (Misc queries) | |||
| how do search a list of numbers to find what adds up to a large # | Excel Discussion (Misc queries) | |||
| searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
Threaded Mode
