How to delete duplicate rows in Excel

Learning Hub Academy Feedback
, , ,
4

@supermanPunch in that excel a column INVOICE124 it’s duplicate only if it is duplicate i want to first one keep it as same value in excel. Second duplicate i need to change the value for example

   A                        B

INVOICE124 bbb
INVOICE124 0

I need this output. Second duplicate i want to replace the value name as 0