checking for certain codes

[marko]

Hi!
1. I have data in columne A (about 4500 diferent codes)!
How could I chech if certain codes are doubling, tripled,... in columne
A and if they are they must be shown in columne B.

2. I have data in columne A (about 4500 diferent codes)!
I write a code in columne B and I want to verify if that code is in
columne A or it is not?

Thanks for your answers!

Marko

 

[Domenic]

Hi Marko,

1. I have data in columne A (about 4500 diferent codes)!
How could I chech if certain codes are doubling, tripled,... in columne
A and if they are they must be shown in columne B.

Put this in cell B1 and copy down,

=IF(COUNTIF($A$1:$A$8,A1)>1,A1,"")

2. I have data in columne A (about 4500 diferent codes)!
I write a code in columne B and I want to verify if that code is in
columne A or it is not?

Put this in cell C1 and copy down,

=IF(COUNTIF($A$1:$A$8,B1)>0,"Yes","No")

Hope this helps!