checking for certain codes

  • Thread starter Thread starter marko
  • Start date Start date
M

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
 
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.
Click to expand...

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?
Click to expand...

Put this in cell C1 and copy down,

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

Hope this helps!
 
Back
Top