hi, I welcomed the FILTER function on LO, however I would like a clarification please because it seems to me to present an anomaly.

I start from a matrix where in the first column there are alphanumeric acronyms and in the two subsequent columns of numbers; I then execute the formula filtering on the first column and the result is this:

if there is more than one alphanumeric acronym, then it works correctly and reports the correct rows and in the remaining part of the matrix #N/A

if there is only one alphanumeric string, then it repeats the corresponding row for the entire filtered matrix

the behavior does not seem correct to me, am I perhaps doing something wrong? Thank you for your observations

In the attached file for tests in cell I2 there is a drop-down menu where you can choose the value of the string.

FILTER_prova.ods (17.1 KB)