识别数组中的子单元格 [英] Identify a child cell in an array
问题描述
在24行的以下数组中,有9个子节点(终端节点) - 为了清楚起见,阴影为黄色。换句话说,除了终端节点,每个条目都有一个小孩。例如,5E有2个两个终端节点。 14G是终端节点,但不是15G。 16H是终端。 17H有2个孩子(终端节点)。 22F还有2个孩子(终端节点)。
In the following array of 24 rows, there are 9 children (terminal nodes) - shaded yellow for clarity. In other words, every entry has a child except for the terminal nodes. For example, 5E has 2 two terminal nodes. 14G is a terminal node, but 15G is not. 16H is terminal. 17H has 2 children (terminal nodes). 22F also has 2 children (terminal nodes).
如何编写标识这些终端节点的excel函数或宏?
How to write an excel function or macro that identifies these terminal nodes?
推荐答案
鉴于您的数据,以下条件格式似乎有效。选择A1:I24,然后使用此CF公式:
Given your data, the following conditional format seems to work. Select A1:I24, then use this CF formula:
=AND(A1<>"",OFFSET(A1,1,1)="")
带有黄色填充的格式。
编辑:以下是CF对话框和工作表的屏幕截图,以作澄清:
Here is a screenshot of the CF dialog box, and the worksheet, for clarification:
这篇关于识别数组中的子单元格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!