How to match values in one column to values in another?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

trib - 24 Jul 2006 07:10 GMT

I have the following question:

I have about 2000 records in Column 1 (a code consisting of letters and
numbers). In Column 2 I have about 1500 records. All of the records in
Column 2 are contained in Column 1. However, since about 500 are
missing I cannot sort the equal values next to one another -

How to make it so that Excel matches the values in Column 2 next to the
same values in Column 1?

I have attached a word file in order to show a sample of what I need.

+-------------------------------------------------------------------+

|Filename: Question.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5077 |

+-------------------------------------------------------------------+

Signature

trib

Reply to this Message

Max - 24 Jul 2006 09:31 GMT

Assuming Series 1 starts in A2 down, Series 2 starts in B2 down

Put in C2:
=IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"")
Copy C2 down to the last row of data in col A

Col C will return the required results
If desired, just cut out col C and paste special as values to overwrite col B

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>
> I have the following question:
[quoted text clipped - 13 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=5077 |
> +-------------------------------------------------------------------+

Reply to this Message

trib - 25 Jul 2006 08:18 GMT

Thanks a lot!

Signature

trib

Reply to this Message

Max - 25 Jul 2006 08:30 GMT

> Thanks a lot!

You're welcome !
Thanks for feeding back ..

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message