There is no "function" that does all that, but you can try these methods:
http://www.officearticles.com/excel/...ft_excel. htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"alethead74" wrote in message
...
I need to know what Excel Formula helps find duplicate records and then
removes or hides them.