How to check a checkbox in a table row Mac Numbers and make all other rows disappear?

Hi BP,

Hide column E, and it looks like this:

E2 contains the formula below, filled down to the end of the column.

E2: OR(COUNTIF(A,TRUE)=0,A2=TRUE)

The table is filtered on column E to show only rows containing "TRUE".

Regards,

Barry

Hi BassPlaya,

I see that you have marked Barry's reply as solved (bravo, Barry!), but you have a further question. I can't give up on a challenge. Here is another way.

My brain works in small steps, so please forgive the extra columns E and F (you can hide them when all is working).

Formula in E2 = COUNTIF(A,"TRUE")

Fill down.

Formula in F2 =IF(SUM(E)=0,"Show",IF($A2,"Show,",""))

Fill down.

Now click on one of your Tick Boxes in column A

And apply the filter as suggested by Barry.

To show all rows again, untick the Tick Box in column A (Tick Boxes used to be called Check Boxes).

Regards,

Ian.

HI BP,

Essentially correct.

E2: OR(COUNTIF(A,TRUE)=0,A2=TRUE)

test 1: COUNTIF(A,TRUE)=0   TRUE if no cell in column A is checked, FALSE if any cell in columnA is checked.

test 2: A2=TRUE     TRUE if the cell in 'this row' of column A is checked, FALSE if the cell in 'this row' of column A is not checked

OR(test 1, test 2)   TRUE if test 1 is TRUE or if test 2 is TRUE, FALSE if test 1 AND test 2 are both FALSE.

Each copy of the formula sets the value in 'this row' of column E to TRUE or to FALSE.

The filter shows only the row(s) containing TRUE

Regards,

Barry