Hi Bob,

Thanks for your reply and your codes

It seems that your codes works to delete the next row if duplicate row
was found and will not work in my case
Sorry, perhaps my post was not clear

In fact, after data filtered, I need to delete the first duplicated
row if duplicated rows found in the column
Based on example below, to delete duplicated row of "k" & "p" found
in row 14 and row 25 only

E.g.

Filtered Row ColJ
2 -
7 -
14 k
25 p
26 -
45 k
49 -
58 p

Regards
Len