View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
 
Posts: 191
Default Deleting Duplicate Cells in one Column.

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