基于没有高级过滤器的其他单元格的过滤器列表 [英] Filter list based on other cell without advanced filter

问题描述

您好，我有一个带有数据验证列表的列表(0和1)

Hello I have a list with a data validation list (0 & 1)

A  0
B  1
C  1
D  0

我正在创建一个按钮，以便每次单击该按钮时，都会根据True语句(1s)生成一个随机的名称列表，而无需重复它们并消除False语句(0s).

I am creating a button so that every time I click on it generates a random list of the Names based on the True statements (1s) without repeating them and eliminating the False statements (0s).

类似这样的东西:

A  0   -->   B
B  1         C
C  1
D  0

我能够创建按钮并使名称不重复，但我缺少如何过滤它们或消除False语句的信息.

I was able to create the button and make the names to not repeat themselves but I am missing on how to filter them or eliminating the False statements.

I used =IF() for the True and False statements
I used =RAND() for the repetition filter  
I used =INDEX() for the creation of the list

推荐答案

您需要根据条件过滤数据.您可以尝试以下.

You need to filter data based on condition. You can have a try on following.

=IFERROR(INDEX($A$1:$A$4,AGGREGATE(15,6,ROW($A$1:$A$4)/($B$1:$B$4=1),ROW(1:1))),"")

这篇关于基于没有高级过滤器的其他单元格的过滤器列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！