Just use Data/Filter/adavnced filter & select Unique records only
---GJC
--
gjcase
------------------------------------------------------------------------
gjcase's Profile:
http://www.excelforum.com/member.php...o&userid=26061
View this thread:
http://www.excelforum.com/showthread...hreadid=529579