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

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" <(E-Mail Removed)> wrote in message
news:7FDC6BFA-0845-44C8-8FE0-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:7FDC6BFA-0845-44C8-8FE0-(E-Mail Removed)...
> > 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
>
>
>

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"MFS" <(E-Mail Removed)> wrote in message
news:442DE8C6-8EF4-4F31-8035-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:7FDC6BFA-0845-44C8-8FE0-(E-Mail Removed)...
>> > 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
>>
>>
>>