I have a lot of data that I need to filter. I did it in another page and that's good... but now I need to put some values in that page... and transfer that data to the original.
This is the formula I'm using:
=FILTER( Responses!A2:E300 ; Responses!D2:D300=B1)
Data will be in Colummn F