基于没有高级过滤器的其他单元格的过滤器列表

本文介绍了基于没有高级过滤器的其他单元格的过滤器列表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您好，我有一个带有数据验证列表的列表(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))),"")