How to find duplicate numbers in seperate columns

  • Thread starter Thread starter mosborne
  • Start date Start date
M

mosborne

I have two two seperate columns say col A and clmn B which both contai
sets of number. What i need is a formula that would search and tell m
if a numbers that appears in columns A is also in column B.
thanks:confused
 
Hi
in C1 enter the following formula
=IF(COUNTIF($B$1:$B$1000,A1)>0,"value in col. A is also in
col. B","")
 
Back
Top