merging various datas and sorting out same data

[Rhon Alvarez]

Hi All,

Please help me come up with a formula for two various datas to be merged but needed to sort out those same datas. example, I have 100 names from my 2012 data and I have to merged these with my existing 2014 data but I need to sort out those that are already existing from 2012 and needs only to retain those that are no longer on my 2014 data.

hope somebody could help. thanks.

 

[azumi]

Pls explain the problem and you expected results with sample workbook, and upload it at the forum

thanks

 

[Rhon Alvarez]

*** merge this two columns (A and C) retaining only one count on those same data/name
and segregating those data from column A not included anymore in column C.***
column Acolumn BMerged listingSorted out Data
Abadilla, LigayaAbadilla, LigayaAbadilla, LigayaAbadonio Ph, Annabel
Abadonio Ph, AnnabelAbalos, EvelynAbalos, Evelyn
Abalos, EvelynAbalos, VirginiaAbalos, Virginia
Abalos, VirginiaAban, CleoffeAban, Cleoffe
Aban, CleoffeAbando, BelenAbando, Belen
Abando, GloriaAbando, GloriaAbando, Gloria

 

[azumi]

Im givin you example with formula, but with your big data, it will slow your computer down like hell, maybe wise if you using VBA to do this.


Regards