Delete duplicate records excel

[Krishna_Sanghi]

Hi everyone,

I am trying to delete dupliactes,
first I used delete duplicate row activity it is not doing anything
then i used delete duplicate range but since range is not fixed, so it is not working
then i tried to create macro and it is also taking a fixed range but range changes for every new sheet.
I am doing something like this

[NIVED_NAMBIAR (NIVED N)]

Hi @Krishna_Sanghi

What validation error is throwing ?

[Akshay07 (Akshay Suryawanshi)]

Hello @Krishna_Sanghi,

Can you please be more specify about on what condition you need you find the duplicate row.

[1996 (Neelima G)]

Hi @Krishna_Sanghi,

Refer this below link:

How to delete duplicate rows in Excel

@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

Hope this helps,

Regards,
Neelima.

[Krishna_Sanghi]

Hi @NIVED_NAMBIAR
Sorry for replying so late. It is not showing any error, just not doing anything

[Krishna_Sanghi]

Hi @Akshay07

let say there are 5 columns if all the columns are same for 2 rows then it should delete one row. No specific condition

[Krishna_Sanghi]

Hi @1996
I have seen the solution but I didn’t understand it. the assign activities in the starting and other thing. My case is quite simple, this solution is different