FILTER alfa or numeric using empty string

A small table with two cells containing alphanumeric values and one with a numeric.


Filter less than "" results in the numeric.


Greater than "" omits the number.

  • FILTER