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