Duplicate info on worksheet

[maribelbalbin]

How do I delete duplicate rows on a worksheet? I have a
database of addresses, I want to keep one person per
household.

Thanks, Maribel

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows