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!!
--
Jamie

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


"Jamie" wrote in message
...
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!!
--
Jamie

Select entire column A
select DataFilterAdvanced 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:

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!!
--
Jamie

This didn't do anything.
--
Jamie


"excelent" wrote:

Select entire column A
select DataFilterAdvanced 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:

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!!
--
Jamie

I want to keep the first instance and get rid of the remainders.
--
Jamie


"Bernie Deitrick" wrote:

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


"Jamie" wrote in message
...
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!!
--
Jamie

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


"Jamie" wrote in message
...
I want to keep the first instance and get rid of the remainders.
--
Jamie


"Bernie Deitrick" wrote:

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


"Jamie" wrote in message
...
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!!
--
Jamie

It worked perfectly for me. Even when the source column was not
sorted.

John.