checkist to create a list
i want to use a checklist of say 20 items and if the user checks 8 of them, another checklist of just the selected items is created on another page.
i want to use a checklist of say 20 items and if the user checks 8 of them, another checklist of just the selected items is created on another page.
This may work for you:
Assuming you have a table like:
This table is called "Base Task List". I added a column (column D) for an aux column (which you can hide).
D2=IF(C2, A2, "")
select D2 and fill down
In a second table:
In the table on the right:
A2=IFERROR(SMALL(Base Task List :: D, ROW()-1), "")
B2=IFERROR(VLOOKUP(A2, Base Task List :: $A:$B, 2, 0), "")
select A2 and B2, then fill down
in both tables the first row is a header
checkist to create a list