Filtering array in memory "does not equal" values and delete those rows

[LlebKcir]

copy column data from one array to another - Code to create colSortedArr fully functional

My google/duckduckgo foo have utterly failed me this morning. Everything I am finding has to do with .AutoFilter on a worksheet. NOT what I need, will not do the job.

2 workbooks:
1 = Master multiple tables with 100+ identical columns in each table.
2 = Comm, with 1 table having 41 column headers that use the exact same column name as the tables from the Master.

As a temp. process of learning, I have successfully made an array from 1 hard coded table in the Master to build an array that is in memory for the Comm containing the columns with their full data.

This full data will, in some cases, be more data than is required. I now need to filter down the data in the Comm array floating out there in memory by the sub-network and delete all rows that do not match the sub-network criteria. Followed by deleting any rows that are empty based on the group column.

The deleting of rows within array searches have also pointed me to ONLY deleting rows within a worksheet, not within an array in memory.

Do I?
1. use some form of filter?
2. loop through the colSortedArr to find the sub-network I am looking for and somehow copy that row to a new array?
2a. if I do #2, do I need to copy the column headers over?
3. other options?

Desired outcome. Data in colSortedArr is 1st filtered on City/Network either !=, or = sub-network and delete all rows that are unwanted. 2nd filter remaining data on the group column if any cells in that column are blank, delete that entire row. 3rd paste remaining data into the Overview2 worksheet in the Comm workbook.

 

[NdNoviceHlp]

Not really filtering arrays. Loop your original array through whatever "filter" requirements U have and create a new array of the "filtered" contents. Here's an example of creating an array of unique values from the original array...

Stupid array problem

I'm trying to pull a huge column of data into an array (500,000 rows), then remove some items that are direct duplicates of previous item, and then basically output it into a new column.... I have been going around in circles for hours now trying to do this and am not getting anywhere.. I...

www.mrexcel.com

HTH. Dave

 

[LlebKcir]

Thank you, I will look over that and see what I can figure out.

 

[NdNoviceHlp]

Never really mentioned how to operate that code which is probably important to U...

Dim NewArray() as Variant, OrigArray() as Variant
NewArray = UniqueArr(OrigArr)

The point being that U pass the array to the function, the function manipulates the array and then returns a new array which it seems is what you're trying to achieve. HTH. Dave

 

[LlebKcir]

NdNoviceHIp, that link I am not seeing what you used as the filter in the code?

 

[NdNoviceHlp]

You are correct. My suggestion is that there is no need to use XL's filter... create your own criteria by code. The code just provides an example of how to manipulate an existing array to create a new array. HTH. Dave