jpynn
New Member
- Joined
- Mar 24, 2004
- Messages
- 23
Hi All,
I was wondering if anyone had any idea which method of finding data is faster
Scenario 1: Using arrays
Select the source data sheet
Input all data into arrays (using a while loop)
Find data by using a for..next loop to check each element until a match is found.
Scenario 2: Using the Find function
Select the source data sheet
Use the find method to extract required info.
To me it would seem that the find function is superior. Especially when the required data/total data ratio is low. However for the application I am designing most of the source data is required (but not all, and not in the same order).
Hoping there is someone out there who has had experience with using both and can recommend which one is better.
thanks.
I was wondering if anyone had any idea which method of finding data is faster
Scenario 1: Using arrays
Select the source data sheet
Input all data into arrays (using a while loop)
Find data by using a for..next loop to check each element until a match is found.
Scenario 2: Using the Find function
Select the source data sheet
Use the find method to extract required info.
To me it would seem that the find function is superior. Especially when the required data/total data ratio is low. However for the application I am designing most of the source data is required (but not all, and not in the same order).
Hoping there is someone out there who has had experience with using both and can recommend which one is better.
thanks.