How to delete duplicate rows in attached sheet


Please find the attachment.

  1. If there is a blank cell in any of the column and email should be triggered.
  2. If there is an duplicate row( The entire row should be a duplicate ) an email should be triggered.
    testfile.xlsx (199.1 KB)

Excel Duplicate.xaml (15.1 KB)

Find this xaml. Messagebox has been given to get duplicate rows & blank cell count.

Hi Bikash,

Thanks For your help and but if click on Xaml file it will show source code it’s not getting download .Can you please send me tha Xaml file …please help me.

Hit Right click and save as to download.

1 Like