How to check whither a text is existed

How to check whither a text is existed

Post by TUZT » Mon, 09 Mar 2009 02:09:01


Please help me.
Example: I have data in Column A as following:
A1: G111
A2: G112
A3: G113
I have updated date in Column C as following:
C1: G112
C2: G113
C3: G114
Now, I want a function or formula to be entered in Column B, so it checks A1
value if it is existed in any of Column C cells, I want it to check all cells
in Column C.
After that I will be able to check the others A2, A3 鈥? Please help me.

--
MFS22
 
 
 

How to check whither a text is existed

Post by T. Valk » Mon, 09 Mar 2009 02:29:36

Try this:

Entered in B1 and copied down as needed:

=IF(COUNTIF(C$1:C$100,A1),"Y","N")

Y = yes, it's there
N = no, it's not there

Adjust for the correct end of range C$100.

--
Biff
Microsoft Excel MVP

 
 
 

How to check whither a text is existed

Post by TUZT » Tue, 10 Mar 2009 03:05:00

Thank you T. Valko (I want to kiss you) you are my hero.

I just adjusted it like this:
=IF(COUNTIF(C$1:C$100;A1);"y";"n")
I changed "," to ";" as you can see

Now it is working very well, thanks T. Valko

--
MFS22


"T. Valko" 賰鬲亘:
 
 
 

How to check whither a text is existed

Post by T. Valk » Tue, 10 Mar 2009 03:24:34

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP