Deleting Duplicate Cells in one Column.
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 |
Deleting Duplicate Cells in one Column.
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 |
Deleting Duplicate Cells in one Column.
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 |
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 |
Deleting Duplicate Cells in one Column.
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 |
Deleting Duplicate Cells in one Column.
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 |
Deleting Duplicate Cells in one Column.
It worked perfectly for me. Even when the source column was not
sorted. John. |
All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com