Is there formula to identify the matching data in Column B?
 

Hi,

I have Column A that has some matching data in Column B. Is there formula to
identify the matching data in Column B? or, maybe create a column C for
placing the matching data?
--
Thank you,
Cpviv

Is there formula to identify the matching data in Column B?
 

one way might be to use COUNTIF function

=COUNTIF(A1:A100,B1)

the result would be the count of B1 in A1:A100