动态列表和空白处理 [英] Dynamic list and blank space filtering

问题描述

我有一个列表，它是两个记录单元格的组合。例如像 A1& B2 。有时候这还没有填补。下面的公式表明它在该领域有 A1& B2 ，所以即使该字段被认为是。

  = OFFSET（CCS_Error_Tracker！$ A $ 5,0,0，COUNTA（CCS_Error_Tracker！$ A：$ A），1） 
  

有没有办法可以配置真正寻找空格？

解决方案

我认为这是你正在寻找的：

  = $ A $ 5：INDEX（$ A $ 5：$ A $ 1048576，ROWS（$ A $ 5：$ A $ 1048576） -  $ B $（$ A $ 5：$ A $ 1048576））
  

I have a list which is a combination of two cells for records. For example something like A1&B2. Sometimes this is not filled however. The formula below sees that it has A1&B2 in the field so regardless it thinks it's fields even though the field would be considered "".

=OFFSET(CCS_Error_Tracker!$A$5,0,0,COUNTA(CCS_Error_Tracker!$A:$A),1)  

Is there any way this could be configured truly to look for blank spaces?

解决方案

I think this is what you are looking for:

=$A$5:INDEX($A$5:$A$1048576,ROWS($A$5:$A$1048576)-COUNTBLANK($A$5:$A$1048576))

这篇关于动态列表和空白处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！