+ Reply to Thread
Results 1 to 2 of 2

Relocate true rows to new tab

  1. #1
    Registered User
    Join Date
    01-14-2007
    Posts
    18

    Relocate true rows to new tab

    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.

  2. #2
    Forum Contributor
    Join Date
    01-24-2007
    Location
    Southampton, UK
    Posts
    137
    One suggestion is as follows . . .

    (a) Create a new column, (column O) which has a formula to check the column of True/False values -

    O3 =OR(AND(M1,M2,M3),AND(M2,M3,M4),AND(M3,M4,M5))
    O4 =OR(AND(M2,M3,M4),AND(M3,M4,M5),AND(M4,M5,M6))
    etc

    Set-up the formula in O3 and simply copy & paste down the column. These formulae check either side of the current value to see if there are at least 3 TRUEs together, and if so the result is also TRUE.

    Rows 1 and 2 require a modified version of the formula . . .

    O1 =OR(M1,AND(M1,M2),AND(M1,M2,M3))
    O2 =OR(AND(M1,M2),AND(M1,M2,M3),AND(M2,M3,M4))


    (b) Use the Data, Filter, AutoFilter menu item over the data and filter based on column O being TRUE.

    (c) Select all the cells (use Ctrl a as a shortcut)

    (d) Paste as values into a separate worksheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1