Skip to main content
Answer

How to delete row if row contain value ="xyz"

  • January 3, 2022
  • 2 replies
  • 131 views

Capture

Best answer by Pradeep Kintali

@Yallaling Bansode​  - we can achieve it couple of ways

 

Excel - open

Loop - All rows in worksheet, inside loop write below if condition

if variable[2]= 'xyz'

Excel - Delete row

 

you can do it another ways also like Excel as DB or read worksheet as a datatable and filter rows and write final output to another worksheet/workbook.

 

If this helps you please do Like & mark as "Best Answer" so it will be helpful for others as well. 

 

Best Regards,

Pradeep.

 

2 replies

  • Author
  • Navigator | Tier 3
  • January 3, 2022

@Pradeep Kintali​  Please can you explain in detail as i am new to AA. i have data in datatable


Pradeep Kintali
Most Valuable Pathfinder
Forum|alt.badge.img+6
  • Most Valuable Pathfinder
  • Answer
  • January 3, 2022

@Yallaling Bansode​  - we can achieve it couple of ways

 

Excel - open

Loop - All rows in worksheet, inside loop write below if condition

if variable[2]= 'xyz'

Excel - Delete row

 

you can do it another ways also like Excel as DB or read worksheet as a datatable and filter rows and write final output to another worksheet/workbook.

 

If this helps you please do Like & mark as "Best Answer" so it will be helpful for others as well. 

 

Best Regards,

Pradeep.