deleting multiple cells

[ElvisFonzarelli]

I have two columns of user name data cells (Column A=2505 names, Column
B=2805 names). Some names are in both columns. Is there a way that I
can sort out the 300 unique cells?

 

[Dave Peterson]

Chip Pearson has a bunch of techniques at:
http://www.cpearson.com/excel/duplicat.htm