VBA-Excel: Array Functions – Filter()

Description:  Filter() Function returns one dimensional array containing the filtered array elements based upon the filter options provided Format: Filter(arrArrayName,FilterValue [, Include[, vbCompare]]) Arguments: arrArrayName Manda­tory Type: Array Array which needs to be filtered