5 Replies Latest reply: Mar 19, 2013 12:12 PM by John Witherspoon RSS

    Remove a range of rows based on condition



      I have multiple, similar Excel files. When I grab the information from them, there is a header block in each, that I need to remove on the load. The problem is that the range of rows varies, BUT I have a reference point - the last row will always have the same string in the first column.


      Do you know if there is a conditional range remove? Or maybe there is a work-around?


      Thank you,



      Siarhei K.