Hey,

I have no idea how to do this:

I have two columns with almost the exact same numbers. What I need to
do is match the columns together so that the numbers that are similar
match each other...for example the list would look like this:

2066078 2066078
2066079 2066078
2066080 2066078
2066081 2066078
2066082 2066079
2066083 2066080
2066084 2066081
2066085 2066082
2066086 2066083


and it should look like this:

2066078
2066078
2066078
2066079 2066079
2066080 2066080
2066081 2066081
2066082 2066082
2066083 2066083

Any ideas?


--
c0nfusEd :{
------------------------------------------------------------------------
c0nfusEd :{'s Profile: http://www.excelforum.com/member.php...o&userid=36327
View this thread: http://www.excelforum.com/showthread...hreadid=561103