需要新手帮助！需要返回在过滤器上选择的值 [英] Need Newbie Help! Need to return value's selected on filter

问题描述

大家好，

这里总新手......我正在尝试返回过滤器的值..

示例：

过滤器类别包括："必须执行"，"必须稍后"，"很高兴"

取决于哪个过滤器被触发，我希望一个单元格返回过滤后的类别而忽略空格（总是会选择空格）。

即如果"必须做"和"必须晚做"被选中，然后返回"必须做，必须做到以后"

或者如果"必须做"，则返回如果已选中，则返回"必须执行"

或者如果"必须执行"和"必须晚做"选择"好好拥有"，然后返回"必须做，必须做到以后做得好"

谢谢!!

解决方案

最简单的方法是使用像

这样的公式

= IF（SUBTOTAL（3，A2）= 1，"必须做"，"&";）& IF（SUBTOTAL（3，A3）= 1，"必须在以后做"，"&";）& IF（SUBTOTAL（3，A4）= 1，"Nice to Have"，"""）

其中A是列对于具有类别，并且A2是具有"必须做"的单元，A3具有"必须稍后执行"的单元。和A4有"很高兴"

你可能会变得比较复杂，但这需要更长的公式 - 它只是没有不要添加很多：

= IF（AND（SUBTOTAL（3，A2）） = 1，SUBTOTAL（3，A3）= 1，SUBTOTAL（3，A4）= 1），"必须做，必须做以后，好有"，IF（AND（SUBTOTAL（3，A2）= 1， SUBTOTAL（3，A3）= 1），"必须做，必须做晚做"，IF（AND（SUBTOTAL（3，A2）= 1，SUBTOTAL（3，A4）= 1），"必须做
，并且很高兴"，IF（AND（SUBTOTAL（3，A3）= 1，SUBTOTAL（3，A4）= 1），"必须做得更晚，很高兴"，IF（SUBTOTAL（3，A2）= 1，"必须做"，IF（SUBTOTAL（3，A3）= 1，"必须稍后做"，IF（SUBTOTAL（3，A4）= 1，"Nice to Have"，"None Selected"） ））））））

您的单元格A2，A3和A4不需要连续....

Hi All,

Total newbie here... I'm trying to return the values of the filters..

Example:

Filter categories are : "Must Do", "Must Do Later", "Nice to Have"

Depending on which filters are triggered, I want a cell to return the filtered categories while ignoring the blanks (blanks would always be selected).

i.e. if "Must Do" and "Must Do Later" is selected, then return "Must Do and Must Do Later"

or if if "Must Do" is selected, then return "Must Do"

or if "Must Do" and "Must Do Later" and "Nice to Have" are selected, then return "Must Do, Must Do Later and Nice to Have"

Thanks!!

解决方案

The simplest thing to do is to use a formula like

=IF(SUBTOTAL(3,A2)=1,"Must Do ","") & IF(SUBTOTAL(3,A3)=1,"Must Do Later ","") & IF(SUBTOTAL(3,A4)=1,"Nice to Have","")

Where A is the column with categories, and A2 is a cell that has "Must Do", A3 has "Must Do Later" and A4 has "Nice to Have"

You can get trickier to do the combinations instead but that requires a longer formula - it just doesn't add a lot:

=IF(AND(SUBTOTAL(3,A2)=1, SUBTOTAL(3,A3)=1, SUBTOTAL(3,A4)=1),"Must Do, Must Do Later, and Nice to Have", IF(AND(SUBTOTAL(3,A2)=1, SUBTOTAL(3,A3)=1),"Must Do and Must Do Later",IF(AND(SUBTOTAL(3,A2)=1, SUBTOTAL(3,A4)=1),"Must Do and Nice to Have",IF(AND(SUBTOTAL(3,A3)=1, SUBTOTAL(3,A4)=1),"Must Do Later and Nice to Have",IF(SUBTOTAL(3,A2)=1,"Must Do", IF(SUBTOTAL(3,A3)=1, "Must Do Later",IF(SUBTOTAL(3,A4)=1,"Nice to Have","None Selected")))))))

Your cells A2, A3, and A4 don't need to be contiguous....

这篇关于需要新手帮助！需要返回在过滤器上选择的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！