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
|