Deleting Duplicate Cells in one Column.

J

Jamie

I have a list of numbers in Column A, Cells 1 through 1607. I need to delete
the duplicate cells. How can I do this? I have read previous posts
regarding this but I do not understand. I am a beginner at Excel. Thanks!!
 
B

Bernie Deitrick

Jamie,

Do you want to get rid of all instances of duplicates, or leave the first instance and get rid of
the remainders?

HTH,
Bernie
MS Excel MVP
 
E

excelent

Select entire column A
select Data>Filter>Advanced filter
click ok to use row 1 as header
Select Copy to another destination
Select Only unike values
Select Copy to (select B1)
Click Ok

Select entire column B
Click and hold in selection border and pull to column A
ok


"Jamie" skrev:
 
J

Jamie

This didn't do anything.
--
Jamie


excelent said:
Select entire column A
select Data>Filter>Advanced filter
click ok to use row 1 as header
Select Copy to another destination
Select Only unike values
Select Copy to (select B1)
Click Ok

Select entire column B
Click and hold in selection border and pull to column A
ok


"Jamie" skrev:
Click to expand...
 
B

Bernie Deitrick

Jamie,

Insert a new column, and use the formula
=COUNTIF($A$1:A2,A2)=1

in row 2 of the new column, and copy down to match your list. Then copy that column and paste
special values to convert the formulas to values.

Then select your entire block of data, sort based on the column with the new list, select all the
cells with FALSE, and use edit / delete... / entirerow

HTH,
Bernie
MS Excel MVP
 
Top