Is there a function......

  • Thread starter Thread starter mftmish
  • Start date Start date
M

mftmish

Good Morning,
Is there a function which would allow me to compare a
column of numbers to another column of numbers to see if
any of the numbers in column A appear in column B?
Thanks!
 
=COUNTIF(Column1,first-cell_Column2)>0

an example

=COUNTIF($A$2:$A$500,E2)>0

copy down adjacent to the column you are checking
and it will return TRUE if a value in E is also in A
 
Back
Top