FILTER function

Occasional Visitor

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

2 Replies

@Echrism54 

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.

NikolinoDE

I know I don't know anything (Socrates)

@Echrism54 

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