try David Mcritchies's pushdown macro
in google serach for this expert's name


"kuansheng" wrote in
message ...

Hi,
I have this problem, What i have on hand is two column of data
containing part number of two different devices. What i am trying to do
is to compare this two column and find out all the part number that is
common to both device and also which part number is unique. And
organise and display this in excel. Anyone know any way to accomplish
it please help.


--
kuansheng
------------------------------------------------------------------------
kuansheng's Profile:
http://www.excelforum.com/member.php...o&userid=30658
View this thread: http://www.excelforum.com/showthread...hreadid=503578