I have a long list of Trues and False.
For every series of 2 trues and less I would like to Hide these rows. I do not want to lose them.
However, I would much rather, take the findings of the x3+more true (rows) and copy these to another tab entirely to be yet processed again. This way the original list of data is still safe and accessible. I am very fond of Input tab, Output tab style.
The Columns of my spreadsheet extend to "M", and then my true false column is "N"
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
TRUE insignificant row, can stay here
TRUE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
TRUE This row is associated with the other bordering Trues(of 3 or more). Relocate!
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
FALSE insignificant row, can stay here
Thank you for reading, I appreciate any help on this project.
Bookmarks