You can only really use the operators dynamically in functions such as COUNTIF, eg:
where B1 may contain the criteria as a string (eg >10, <>apple)
Inserting a COUNTIF into your Array is not viable
(edit: not impossible [pending criteria set up] but it would require your Array become Volatile c/o OFFSET)
So given the above restriction you're really left with either
a) using an Evaluate type approach such that you can build a formula string and have it evaluated
think of the Evaluate route as being INDIRECT-esque only here the string is being converted to a formula rather than a Range
(note: this requires use of either i] VBA or ii] old XLM4 call via Defined Name)
b) using a CHOOSE type approach such that you have all bases covered in the formula and choose the most appropriate.
Bookmarks