Hello.
Looking for a way to extract elements from a two dimensional array, which meet a specified criteria, and copy to a new two dimensional array.
Or...
remove all elements from array if they do not meet the specified criteria.
Please Login or Register to view this content.
Last edited by kosherboy; 10-13-2021 at 12:09 AM.
So what are the criteria
This is an example of how you clear specific items of an array.
Not sure what you really want to do with cells that meet the criteria. In this case I just gave them an empty value and put everything back in the sheet.
Please Login or Register to view this content.
Last edited by JEC.; 10-12-2021 at 04:21 PM.
could be anything, let's say Arr(i, 1) = 1:
Please Login or Register to view this content.
Not sure what you really want to do with cells that meet the criteria. In this case I just gave them an empty value and put everything back in the sheet.
Exactly as you have it, copy the new or modified array to a worksheet. I found this to be the fastest way to paste.
I have a question though, you didn't entirely remove the elements from the array, this results in many skipped rows. Looking to paste new array as is. So let's say 7 records meet the criteria out of the 244 records, therefore would like to paste the new array (of 7 records) into Range ("A2:H8")
In addition, your code is only removing part of each record, not the entire record.
Last edited by kosherboy; 10-12-2021 at 04:48 PM.
But your array is larger than 7 records. How do you know where to put the records, which meet the criteria, in the new array?
It seems like you are talking about rows.
Do you only want to loop through column A?
Please Login or Register to view this content.
Last edited by JEC.; 10-12-2021 at 05:07 PM.
I'm trying to achieve the following:
Extract data from 8 columns with dynamic number of rows and copy to array that has 8 different "columns".
The reason I don't already specify the criteria, when copying the range, is because it takes longer to iterate through an excel range than it does on an array.
I then want to iterate through the array and copy the records (which meet the criteria) to a new array (or remove irrelevant records) and paste that array to a new sheet.
If I were to skip the arrays and just deal with excel range then process is considerably slow.
Still not very clear to me unfortunately. You could give the macro in post 5 a try.
If that's still the wrong result, you should post some sample data.
If the goal is to paste the result to a range then it should work:Originally Posted by kosherboy
the NewArr could have empty rows at the bottom but because I set the range only to x row then only the non empty part will return to the rangePlease Login or Register to view this content.
Re: Extract specific elements from 2d array and add to new 2d array
Just using a fast enough advanced filter, done with two codelines …
Very well written, and exactly what I was looking for!
Thank you!
Last edited by kosherboy; 10-13-2021 at 12:12 AM.
You're welcome, glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks