How to remove duplicates in excel on keywords

Hello guys
i’ve to delete particular row which is repeating i’ve to retain the first row value and delete the rest

Hi @Pradeep_Shiv,

Please check this link:

Karthik Byggari


You can use - Remove Duplicate Rows Activity

Please refer this page for further details:

Other helpful source from @HareeshMR

Srenivasan Kannan

1 Like

we have an inbuilt activity now. Also check the below one -

Karthik Byggari

i’ve to delete one particular value not all other duplicats

You mean you want to delete the duplicate of one particular row and leave the rest?
Go with VB code to do the required @Pradeep_Shiv

exactly ,how do i do that

  1. Loop through the headers of the excel
  2. check for the particular header you have
  3. Initialize the variable of type integer and then assign it to 1
  4. Continue the loop and if the same value occurs again, increment the value by 1 and then delete the entire column so that you will remove the second occurrence of that header.