VBA-Excel: Array Functions – Filter()

Descrip­tion:  Fil­ter() Func­tion returns one dimen­sional array con­tain­ing the fil­tered array ele­ments based upon the fil­ter options pro­vided For­mat: Fil­ter(arrArrayName,FilterValue [, Include[, vbCom­pare]]) Argu­ments: arrAr­ray­Name Manda­tory Type: Array Array which needs to be filtered