The purpose of the Filter() function is to filter out parts of a set that is not required in a given situation and the function returns a subset of a larger set. Uses of the Filter() function can range from the sublimely simple to the impressively advanced, and it can be used in many innovative ways. The objective, of course, is the support of precise analysis to meet the business needs.