Data in array, clear all rows if column values do not equal x and y

[JackDanIce]

Hi,

I have data in an array but need a subset of this data where Column 5 <> "Setup" or Column 5 <>"Jack"

Closest code found but unable to adjust is:

Function SubSet(ByRef WholeSet As Variant) As Variant

SubSet = Application.Index(WholeSet, "" <> "" & Array("Setup", "Jack"), 5)

End Function

Gives run-time error '13' Type mismatch, I'm guessing my 2nd argument is incorrect.

Can anyone suggest please?

TIA,
Jack

 

[LlebKcir]

I'm in a similar boat, I have 1 column I want to filter on a string another column i want to filter on blanks.

Keep column City/Network matching XYZ string (all rows)
delete all rows that are blank in column Group

Make 1 or 2 new arrays from the current array I have floating out in memory.