Skip to main content
Navigator | Tier 3
January 3, 2022
Solved

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

  • January 3, 2022
  • 2 replies
  • 207 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

    YallalingAuthor
    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
    Most Valuable Pathfinder
    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.