excel - data validation list based on checkbox value

Question

right now i have a table with information like company name and stuff.

after each line in the table there is a checkbox.

i also have data validation list that references to that table.

is there any way that only the lines in the data validation show if in the table the checkbox behind a line is ticked?

so for example i have this

**name checkbox**
test checked
klas unchecked
klek checked

and then in the list in only shows test and klek and not the klas option since that is unchecked.

标签： excel

Answer 1

下载文件并检查它。

示例文件下载链接

我认为这会更容易，但事实并非如此。我相信要花几个小时才能理解公式发生了什么。