Hi
I had same problem like "alrikvincent" to "Remove duplicate entries from one column and output it into another column using formulas" but i solve it by "Tony Valko" method in this post:
http://www.excelforum.com/excel-form...-formulas.html

But I have a problem.
I did what Tony said and result was very good. But when I filter some cloume on source to change calculations, that filterd values didnot removed on formula Tony's created. may help me on this please ...