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

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?
 
J

Jarek Kujawa

one way might be to use COUNTIF function

=COUNTIF(A1:A100,B1)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tagging Misspell Words with "##" 0
Extracting a cell value 2
index,match - how to avoid same lookup when duplicates present 1
Copy addition formula of non-consecutive horizontal cells 2
Index / Match Formula Problem 4
Changing column reference for number of formulas at once 1
if statements for multiple entries 1
adding multiple values from matched search results 3

Top