How to check whither a text is existed
 

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
 

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


"MFS" wrote in message
...
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
 

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" كتب:

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


"MFS" wrote in message
...
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
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"MFS" wrote in message
...
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" ???:

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


"MFS" wrote in message
...
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