how to filter duplicate data between column?

[kerplunk]

hai there..
greetings!!

thx for advance for your kind help..
i hav prob here..
how i want to appear data that is unique between column?

e.g:
a1-abc
a2-abc
a3-acc
a4-abb

b1-abb
b2-acb
b3-adb
b4-adb

so i want to generate column c with..
c1-abc
c2-acc
c3-acb
c4-adb

it's meant column C will display a unique number that display only in column A or B ..it may not display the data if it appear in both column A and B..but the data may display multiple time in the column itself..like example above..abc appear two times in column A but it not appear in column B..so it consider unique to the column C..

i really appreciate your kind help and effort..
thnk you very much..

kerplunk

 

[Sektor]

In Excel 2007/2010 select data and go to Data tab -> Remove Duplicates.

 

[moonfish]

You will need two columns for this, one for each column in your source data.

In column c:
=IF(ISNA(MATCH(A1,$B$1:$B$4,0)),A1,"")

In column d:
=IF(ISNA(MATCH(B1,$A:$A,0)),B1,"")

Then copy these cells down across the length of your data.

These lists will still contain duplicates, but none of the duplicates will be found in more than one column.

 

[kerplunk]

Thx for the sektor and moonfish for your kind reply..

Actually i found one worksheet that really suit with what i want...

http://www.cpearson.com/excel/ListFunctions.aspx
(under "Extracting Elements From One List Not On Another List")

It use "In 1 not 2" basis..

I "download a example with these formula here" but that worksheet only have a range until 10 element only..

Anyone can help me how to prolong the list until 1000 because i have that much data to filter..

Once again thx you very much for ur kind help and concern..

regards...