我有层次结构路径值:
FLEET
FLEET \ AIR SYSTEM
FLEET \ AIR SYSTEM \ COMPRESSOR - DRYER
FLEET \ AIR SYSTEM \ VALVES
FLEET \ AIR SYSTEM \ RESERVOIRS
FLEET \ AIR SYSTEM \ HOSES - LINES - FITTINGS
FLEET \ ATTACHMENTS
FLEET \ ATTACHMENTS \ BLADE
FLEET \ ATTACHMENTS \ SALTER
FLEET \ ATTACHMENTS \ BROOM
FLEET \ ATTACHMENTS \ MOWER
FLEET \ ATTACHMENTS \ HITCH
FLEET \ ATTACHMENTS \ MISCELLANEOUS
["FLEET \ BODY EXTERIOR" --> parent is missing]
FLEET \ BODY EXTERIOR \ BODY PANELS
FLEET \ BODY EXTERIOR \ WIPERS
FLEET \ BODY EXTERIOR \ MIRRORS
FLEET \ BODY EXTERIOR \ ACCESSORIES
FLEET \ BODY EXTERIOR \ ACCESSORIES \ CATEGORY 1
FLEET \ BODY EXTERIOR \ ACCESSORIES \ CATEGORY 2
我正在努力寻找没有父母的孩子。
例如,我想指出第 17-20 行缺少第 16 行中的父项。
有没有办法在 Excel 中做到这一点?
一个解法:
该公式标记了孤立的层次结构路径(没有父级的子级)。
解释:
1)从层次结构路径中删除最低级别:
2)
countif
用于确定步骤 #1 中的值是否存在于 A 列中。换句话说,检查该父级是否存在。