Matching numbers in two columns

[Bing]

I am experiencing some difficulties matching numbers in two columns in Excel. My project requires me to figue out whether all the numbers in column A can be found in column B. Can anybody tell me how to do it? Thank you very much.

 

[dangre]

Not sure if this is the easiest or best way to go about this, but it works for me. Try copying your two columns to another worksheet.

1. Change the font color of column A
2. Cut column A and paste it in column B, underneath the last value in this column.
3. Sort Ascending (A-Z) Now you should have just one column containing all data.
4. In the next column over, insert this formula - IF(B1=B2,"Match","")

Hope this works for you.

 

[dangre]

Add on to my last post:

Drag your formula =IF(B1=B2,"Match","") down to the last value in column B

 

[Aladin Akyurek]

On 2002-05-30 11:28, Bing wrote:
I am experiencing some difficulties matching numbers in two columns in Excel. My project requires me to figue out whether all the numbers in column A can be found in column B. Can anybody tell me how to do it? Thank you very much.

In column C enter and copy down as far as needed:

=(COUNTIF(B:B,A2)>0)+0

where A2 houses the first entry to check whether it is also in B.

The formula gives 1 if A-entry occurs at least once in B, otherwise 0.

You can also use conditional formatting on A to hilite the entries that are also in B.
This message was edited by Aladin Akyurek on 2002-07-23 06:25

 

[jameshomer]

Cheers.

That solution works great.
And in record time too