Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I have a list of DVDs in one sheet which are categorised etc. as well as having true/false checkboxes to mark whether they have been watched.
Is there a way of populating a second sheet only with the rows that are marked "FALSE" in the "Watched" column?
Late 2008 Macbook 13-inch, Mac OS X (10.6.2), 4GB, 320 GB
Yes, but you migth find it just as efficient to filter the first table to show only rows where the checkbox is unchecked.
Here's a method for showing the list on a second table (whih may be placed o a second sheet).
Add an Index column ( C ) to the Data table.
C2, and filled down: =IF(B=FALSE,COUNTIF($B$2:B2,FALSE),"")
The second table, Not Watched, uses the formula below to retrieve the titles of the indexed (ie. not watched) DVDs.
A2, and filled down: =IF(ROW()-1>MAX(Data :: $C),"",LOOKUP(ROW()-1,Data :: $C,Data :: $A))
Th IF part at the beginning acts as a switch to stop LOOKUP when the last unread title has been retrieved.
Regards,
Barry
Yes, but you migth find it just as efficient to filter the first table to show only rows where the checkbox is unchecked.
Here's a method for showing the list on a second table (whih may be placed o a second sheet).
Add an Index column ( C ) to the Data table.
C2, and filled down: =IF(B=FALSE,COUNTIF($B$2:B2,FALSE),"")
The second table, Not Watched, uses the formula below to retrieve the titles of the indexed (ie. not watched) DVDs.
A2, and filled down: =IF(ROW()-1>MAX(Data :: $C),"",LOOKUP(ROW()-1,Data :: $C,Data :: $A))
Th IF part at the beginning acts as a switch to stop LOOKUP when the last unread title has been retrieved.
Regards,
Barry
Is there a way to create a list in a new sheet based on a value within an entry on the first sheet?
