Duplicated lines in a data table
 

Does anyone know of any functionality in Excel to easily identify and
remove duplicated lines in a data table?

I have a buggy reporting system which we are due to replace but in the
meantime I am stuck with it as the development is focused on the new
system. It produces reports with rows which are duplicates of other
rows, so I need to get rid of these before I can use it to produce
useful information.

Thanks

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=549987