| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
most efficient way to filter out and iterate through datasets in X
Hi all,
I am currently doing some rapid prototyping in VBA-Excel2003. Excel is used as lightweight relational database, hence requiring frequent selection of 'records/rows' based on multiple criteria. The selections then are transformed into arrays in order to present them in listboxes. What is the most efficient/performant way to filter out the relevant information ? autofilter ? advancefilter ? find(next) ? for each r in rows - loop ? tnx in advance, kind regards, Bart Wouters |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I iterate numbering when printing | Excel Discussion (Misc queries) | |||
| what's the command for erfc iterate integrals? | Excel Worksheet Functions | |||
| Iterate Circular Reference | Excel Discussion (Misc queries) | |||
| Iterate though all open spreadsheets | Excel Worksheet Functions | |||
| How do I fill down formulas so they iterate in intervals other th. | Excel Worksheet Functions | |||
![Bart Wouters[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
