If your data does not contain numerical values, you could simply
replace...

="A"

with

<""

Is this the case?

In article ,
SteveC wrote:

Domenic, thanks! That works if I input "A" anywhere in the range A1:E5.

Is there a way to make it work for any text value? It doesn't work with "B"
or "Apples", for example.

Thanks very much!
SteveC