Hi
See Chip pearsons site
http://www.cpearson.com/excel/duplicat.htm
My Add-in have a duplicate option also
http://www.rondebruin.nl/easyfilter.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"PAL@Emory" wrote in message ...
I have a very large spreadsheet of data received from another application and
need to delete the duplicate rows from it. I tried to follow the
instructions on this site for Excel 2003, but the "Show All" option was
grayed out under Data -- Filter. I had found the proper instructions
several weeks ago, but can't find it again for Excel 2000.