|
Posted to microsoft.public.excel.programming
|
|
|
removing duplicate rows
Hi
as a starting point:
http://cpearson.com/excel/deleting.h...eDuplicateRows
"neowok" wrote:
should be pretty simple one. What I need is some sort of macro which
searches my entire 5000 row spreadsheet between column A and R only and
completely removes the duplicate rows (i.e. deletes the row and shifts
the others up). Duplicate rows could be any distance apart i.e. row
300 and row 4500 so its not just a matter of comparing one row to the
next.
anyone?
--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=314390
|