Deleting Duplicate Enteries
Posted by Tim Watson on August 06, 2001 2:29 PM
I often work with lists that cover a time period (ie, All deliveries accomplished by a delivery company between 1/1/01 & 7/30/01). These deliveries are being made to roughly the same group of people... (Some people in the group ((known as 'consigness'))receive monthly deliveries, some only 1 or 2 occasions over the time frame.) The list may show the name 'Bill Jone' in 'Alameda, CA' five times. I need to be able to take a given list and remove any duplicate consignees to eventually end up with a complete list of the total number of consigness being delivered by a given delivery company. Is there a way to remove duplicate enteries in Excel 2000? Help! this has been driving me nuts!