FILTER function

Occasional Visitor

Is there a way to filter in place with the FILTER function ?

2 Replies


Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!

Ask away, but please read the information in the upper link beforehand.


Additional Information/Link:

Filter data in a range or table

Related Topics

Excel Training: Filter data in a table

Guidelines and examples for sorting and filtering data by color

Filter data in a PivotTable

Filter by using advanced criteria

Remove a filter


Hope I was able to help you with this info.


I know I don't know anything (Socrates)


FILTER() function returns filtered array into another place, as any other function returns the result into new place. It doesn't work in place.