With your data in Columns A and B

D1: Criteria
D2: =COUNTIF(A$1:A2,A2)1

DataFilterAdvanced Filter
List Range: (Select from A1 to the last item in col_B)
Criteria: $D$1:$D$2
Click the [OK] button

(That filter will hide the 1st instance of items in Col_A and only display
records with duplicates.)

Select from A2 through the bottom of the displayed list.
EditDeleteRow

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"AskExcel" wrote:

Hi,
i want to delete duplicate data in column code with disregard to other
column data. if i use data - filter - advanced filter, this cannot solve my
problem. for example
i just want to delete duplicate record in column code by disregard the
column misc

code misc
1200 40
1300
1300 76
1300
1500
1500 12

after
code misc
1200 40
1300
1500 12

if i use the data - filter - advanced filter
the result is
code misc
1200 40
1300
1300 76
1500
1500 12