Alan Beban wrote:
|| Gordon wrote:
||| jsm wrote:
||||| I have a spreadsheet of data with multiple occurrences of
||||| duplicate rows. I need to know how to find and remove the
||||| duplicate rows of data to prevent double counting.
|||
||| Try he
||| http://www.cpearson.com/excel/deleti...eDuplicateRows
|||
||
|| The cited link has code to delete rows in which a value in a single
|| column is duplicated; is that what the OP meant by "duplicate rows"?
||
|| Alan Beban

I agree - the page is a bit ambiguous, isn't it? The illustrations would
suggest that the macro does what the OP wants, but the text might have a
different interpretation!
There is a link to other "duplicate" workarounds at the bottom. I usually
find that site very good!

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk