i have excel sheet with 4 rows.
i want to remove the duplicate records.
i applied logic read range into Data table and compared with other columns.
now i removed 1,3 rd and 4th rows and inserted into other excel sheet. then already data is contains the data table with 4 records but reality is deleted the 3rd, 4th and 1 st rows.
it is trying to find the any duplicates with 3 rd row. and found 4th row so in excel sheet again adding 3rd, 4th row second time. any suggestions. how to update the data table data inside the for each row.