Ask Your Question

dkso9's profile - activity

2014-09-17 13:48:01 +0200 answered a question If Then for cell value automatically delete row

Make a copy of your sheet. Insert a new column at the start of the sheet (A - first column). Make an if-then that shows a 1 or some other value if the condition is met, and nothing if not. Then sort on that first column, expanding to all columns. The rows with empty first column value will be on top or bottom. You can delete them in one go.

If you need to reset the order to the previous state, you have to do some other tricks. Insert another column (B), first row (B1) enter value 1, then B2=B1+1. Then copy B2 to the rest of the column rows. Then insert another column (C). Paste the value of B to C, but make sure it copies the values (1,2,3,...), not the calculations. Then do the sorting of A, remove the empty A rows, then sort on C.