Hi,

Im having trouble with duplcate entrys in a very large spreadsheet.
Some customers details are duplcated in spreadsheet, if so they are
always listed in adjacent rows directly below. Therefore I need to
search in one column and delete the entire row if the cell matches the
cell directly above it.

any help would be much appreciated,
Many thanks,
Andrew


--
Shandy720
------------------------------------------------------------------------
Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230
View this thread: http://www.excelforum.com/showthread...hreadid=565927