Filter individual cells without removing the entire row

[Steffi]

Hello,

I am importing numerical data into calc.
I would like to know if it is possible to filter out the outliers without removing the whole row with a filter or searching for and replacing a specific value.

For example, I would like to filter out each cell that has a value greater than 20 or less than 10, and replace them with a 0 or a blank cell.
I also need a macro to do so.
Any help would be much appreciated.

Thanks.

[Villeroy]

=OR(A1>=10;A1<=20)*A1
=AND(A1>=10;A1<=20)*A1

[RusselB]

Villeroy's suggestion is a formula that would go in a different column.
You can get the same results using the Standard Filter or Advanced Filter (but not Auto-Filter).
Due to the relative simplicity of your example, I would recommend using the Standard Filter.
Note: With either Villeroy's suggestion, or mine, all of the data should be imported first. Neither of these are for attempting to import just the filtered content into the spreadsheet.

[Villeroy]

outliers.ods

(16.13 KiB) Downloaded 78 times