Remote Desktop Connection hotkey
Re: Search column for value and return TRUE or FALSE
Thanks man.... i can't understand why i couldn't come up whith this myself
"Bob Umlas" wrote:
> =NOT(ISNA(MATCH(B1,A1:A10,0))) where B1 contains the criteria to search
> Bob Umlas
> Excel MVP
> "Remote Desktop Connection hotkey"
> <RemoteDesktopConnectionhotkey@discussions.microsoft.com> wrote in message
> > 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