Hi Wira,
See Chip Pearson's formula approach at:
http://www.cpearson.com/excel/duplic...tingDuplicates
For your immediate purposes, look particularly at the last two sections on
this page.
---
Regards,
Norman
"wira" wrote in message
...
Hi guys,
I need to do some cell matching between 2 lists. Let say i have a source
and
target list at column A and B from seperate w/sheet. Starting from the
top,
the program will detect cell one by one and try to match it with the
target
list from the other w/sheet. That one is not a problem for me, the only
problem is there are some of the cells from source list that are not in
the
target list and vice versa. How to pin point the cells and copy it to
another
w/sheet.
Appreciate ur help,
wira