Not sure what I was thinking when I used COUNT(FIND()) instead of
COUNTIF, but COUNTIF(), does not work if you pass an entire column as
the range.

Jerry

JulieD wrote:

haven't had time to think through a solution, but i just wanted to respond
to Jerry's post about

I am not aware of any Excel function or combination of functions that can
test for "Any cell in Column AA=A1"

the countif function can be used for this
e.g.
=COUNTIF(AA:AA,A1)
will give you the number of times it is found and
=IF(COUNTIF(AA:AA,A1)=1,"found',"not found")
will give you whether or not it is found

hopefully will have time for a more detailed answer later on ...