How can I get rid of duplicates in a column?
 

I have a column of loan numbers. This column contains duplicated loan
numbers. I want to get rid of all the duplicates without having to go thru
each one and manually deleting the entire row. Any suggestions? THanks

How can I get rid of duplicates in a column?
 

See:

http://www.cpearson.com/excel/Duplicates.aspx


--
Gary''s Student - gsnu200836


"trainer07" wrote:

I have a column of loan numbers. This column contains duplicated loan
numbers. I want to get rid of all the duplicates without having to go thru
each one and manually deleting the entire row. Any suggestions? THanks

How can I get rid of duplicates in a column?
 

DataFilterAdvanced Filter

Unique records only and Copy to a new location.

For more details see

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 11:53:02 -0800, trainer07
wrote:

I have a column of loan numbers. This column contains duplicated loan
numbers. I want to get rid of all the duplicates without having to go thru
each one and manually deleting the entire row. Any suggestions? THanks