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

    Remove a range of rows based on condition

      Hi,

       

      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.