I have a Array with two fields of values.
I need to be able to filter the array so it only contains rows/records where the second column/Field equals a certain value (ie 5).
Can this be done with out copying to a worksheet and filtering the data?
(This filtering will need to be done fairly constantly while the project is being used.
Also it's only about 300 records so pasting to a worksheet, filtering and copying back seems an overkill)