COUNTIF wont find dublicate numbers

[Niklas Johnsson]

Hi im having som trouble with the COUNTIF function. 

I have 2 kolumns with numbers and im trying to see wich of the numbers in kolumn a that is in kolumn b. This usually works for me with COUNTIF by writing a2;b.b but now it does wont find any, the only result i get is 0. What am i doing wrong you think? 

I know for a fact that there is duplicates since i can find them by serching for one of the numbers. 

[#2 · Accepted solution]

Hi Niklas,

You can use COUNTIF as below:

=COUNTIF($A$1:$A$18,B1)

Please note that you have to put the targeted range in Column A in the first argument of the function, then put the criteria which is a cell in Column B.

Regards

[#3]

Greetings! Have tried with MATCH function, please find attached file. Hope it helps, Thanks