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

  • Thread starter Thread starter Cpviv
  • Start date Start date
C

Cpviv

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?
 
one way might be to use COUNTIF function

=COUNTIF(A1:A100,B1)

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