Comparing columns

D

Dave T

I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
this please?

Many thanks
DT
 
J

Jacob Skaria

Suppose you are comparing ColA and ColB. In Col C use the below formula

This will compare the entry in B1 aganist column A and if found return
"Found" or else "Not Found"

In C1 use the below formula and copy down as required.

=IF(COUNTIF(A:A,B1)>0,"Found","Not found")

If this post helps click Yes
 

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

Compare columns of numbers 2
Comparison of Microsoft Outlook 0
Column comparing 1
Macro to select and delete levels of a document 2
Column comparison 2
Inconsistent formatting of section numbers 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0

Top