excel透视表计数去重
It seemed simple enough, but counting the AutoFilters on an Excel sheet is a tough job! The answer to "How many worksheet AutoFilters are there?" is "It depends!"
看起来很简单,但是在Excel工作表上计算自动过滤器是一项艰巨的任务! 答案是“有多少个工作表自动筛选器?” 是“取决于!”
You can read the fascinating (to me!) results below.
您可以在下面阅读引人入胜的(对我来说!)结果。
过去的好时光 (The Good Old Days)
In the old days, before Excel 2003, you could only have one AutoFilter on a sheet. That's pretty easy to count – either 1 or 0.
过去,在Excel 2003之前,工作表上只能有一个自动筛选。 这很容易计算-1或0。
For example, this Excel 2010 sheet has a single list that is not a named table. An AutoFilter was applied to this list, and the AutoFilter arrows have been turned off.
例如,此Excel 2010工作表具有一个不是命名表的列表 。 AutoFilter已应用于此列表,并且AutoFilter箭头已关闭 。
If you point to one of the headings, where the hidden arrow is, the tooltip for that filter appears, so that shows us the AutoFilter is still active.
如果您指向其中一个隐藏箭头所在的标题,则会显示该过滤器的工具提示,从而向我们显示自动过滤器仍处于活动状态。