New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
How to Delete Rows with duplicate values in 1 columns in excel thru QTP.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to Delete Rows with duplicate values in 1 columns in excel thru QTP.
arpan Offline
Junior Member
**
Posts: 30
Threads: 16
Joined: Jun 2013
Reputation: 0
#1
Not Solved 02-09-2015, 08:47 PM
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
Find
Reply


Messages In This Thread
How to Delete Rows with duplicate values in 1 columns in excel thru QTP. - by arpan - 02-09-2015, 08:47 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Comparing two unsorted excel columns ProTester 2 2,803 09-13-2018, 02:11 PM
Last Post: ProTester
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,714 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  How to delete prepopulate value in powerbuilder qtp-tester 1 1,874 07-04-2016, 06:43 PM
Last Post: venkatesh9032
  How to get center data value in a odd number of rows and columns web table ... sai rajesh 0 2,797 11-13-2013, 10:24 PM
Last Post: sai rajesh
  Delete icon in System tray arpan 2 4,064 07-12-2013, 07:38 PM
Last Post: arpan

Forum Jump:


Users browsing this thread: 2 Guest(s)