I have a spreadsheet , that I have attached. There are thousands of rows that we want to delete automatically if a certain condition is true.
The rows represent unique records that are kind of nested. We want to delete the rows associAted with the "ABC STAR" as an example:
10017410203395 REBECCA BUFFINGTON FOR DCB 10/31/2013 US
IJR ISHARES CORE S&P SMALL-CAP E 32.000% 30.680% 1.320%
CASH 3.000% 4.010% 1.010%
if we find PNC STAR, we want to delete the row above "10017410203395 ...." and delete the rows following PNC STAR until we hit the next occurance of 10017...." . We want to repeat this until all rows are deleted that we want. in the example spreadsheet you will see : We do not want those rows to be deleted. Is there anyway to write a macro or something to do this? This is example data and does not contain and private or confidentail information.
I have tried using the statement in Column C , but its marking everything as delete. However if you look at row 159 -161 those should be marked as Keep, as they dont contain PNC Star.