+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: How to Delete Rows with duplicate values in 1 columns in excel thru QTP. (/Thread-How-to-Delete-Rows-with-duplicate-values-in-1-columns-in-excel-thru-QTP)
How to Delete Rows with duplicate values in 1 columns in excel thru QTP. - arpan - 02-09-2015
Hi Guys,
I've an excel sheet with 5 columns and 10 rows. I want to check if there are any duplicate values in column B. If i find duplicate values, i want to delete both rows. How can i achieve this using QTP? I've done lot of research but couldn't find an answer to this specific situation. I've the code which would delete one of the duplicate value, but i want to delete both values. Can someone help me out with this?
Thanks
Arpan