Needs macros to delete row ranges in excel
Posted on 2016-08-18
I would like to delete a range of rows, but not the top row, that are missing a string in a certain column.
In this particular question I am looking for all of the latest Android Marshmallow devices where are identified by the string "Linux; Android 6.0.1;" in column W. The row header is "USER_AGENT" and I don't want to delete that one either.
All other rows are to be deleted.
This is a huge spread sheet (65000 rows+) and I don't want to do this manually.