Prev: loop
Next: Subtotal function is grayed out - Excel 2007
From: DColeman on 18 Mar 2010 10:58
I have put my Palm Pilot contacts in Excel. The fields are not all the same
and there are many duplicates. Not all same names are exactly identical. I
want to run a formula that will automatically delete duplicates if just the
names (first and last) are the same. Some info in the rest of the lines may
be different for various reasons. I don't care. Rather just have one entry
for everyone. Does anyone know how to do this?
From: SueW on 18 Mar 2010 14:43
In Excel-Data tab>Data Tools Command Group>Remove Duplicates. Select the
column(s) you have duplicates in and want removed.

"DColeman" wrote:

> I have put my Palm Pilot contacts in Excel. The fields are not all the same
> and there are many duplicates. Not all same names are exactly identical. I
> want to run a formula that will automatically delete duplicates if just the
> names (first and last) are the same. Some info in the rest of the lines may
> be different for various reasons. I don't care. Rather just have one entry
> for everyone. Does anyone know how to do this?
 | 
Pages: 1
Prev: loop
Next: Subtotal function is grayed out - Excel 2007