Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to delete duplicate in one time
Dear Sir,
Here I am working in a excel sheet and I am making item code detail. but some item codes are showing dulicate I want to delete all duplicate code in a one times can u pls.give me short command. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to delete duplicate in one time
Assuming data is in column A starting row1:
Put this formula in a "helper" column and copy down to end of items: =IF(COUNTIF($A$1:A1,A1)1,"Duplicate","") Highlight helper column Then Data==Filter=AutoFilter Select "Duplicate" Right click on higlighted Duplicates "Delete Rows" TEST First! (backup your data!) " wrote: Dear Sir, Here I am working in a excel sheet and I am making item code detail. but some item codes are showing dulicate I want to delete all duplicate code in a one times can u pls.give me short command. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to delete duplicate in one time
Assuming your duplicate entries are in column A and that entries begin on row
2, and that column B is an empty column you can use for this: Put this formula into cell B3 =COUNTIF(A$2:A2,A3) and fill the formula down the sheet. You will see numbers like 0, 1, or greater. The rows with 0 are entries that are not duplicated above it. Any non-zero number means the entry in A appears more than once. Choose Data | Filter | Auto Filter Then in the column with this formula (B in our example) click the little pull-down arrow and choose Custom. Select 'greater than' for the condition, and 0 for the value. Now only your rows containing duplicate data should be displayed. Select all of the rows and use Edit | Delete | Entire Row Turn off Auto-filtering and only your individual entries will be left. You may want to make a copy of the sheet to practice this on so if something goes awry (shouldn't) you'll still have the original data to start over with. " wrote: Dear Sir, Here I am working in a excel sheet and I am making item code detail. but some item codes are showing dulicate I want to delete all duplicate code in a one times can u pls.give me short command. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete duplicate rows | Excel Worksheet Functions | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
How do I delete duplicate cells? | Excel Worksheet Functions | |||
Delete Duplicate | Excel Discussion (Misc queries) | |||
How do I delete duplicate entries? | Excel Worksheet Functions |