=NOT(ISNA(MATCH("x",A1:A10,0)))
or
=NOT(ISNA(MATCH("-x",A1:A10,0)))
or
=NOT(ISNA(MATCH(B1,A1:A10,0))) where B1 contains the criteria to search
Bob Umlas
Excel MVP
"Remote Desktop Connection hotkey"
<[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> I function that would search through column of text values (range with 1
> column) and return TRUE if column contains value given as criteria or
> FALSE
> if there is no such value in given column
>
> For example i have range A1:A10 and i want to find out whether this range
> contains value x or - x
Bookmarks