I am trying to build a column to count the # of times a predecessor appears in the predecessor column. The below formula has almost gotten me there, but it is also counting predecessor cells that include 1, but not exactly 1 (like 12, 21, 100, etc...)
=COUNTIF(Predecessors:Predecessors, FIND(1, @cell) > 0)
Is there any way to search for exactly 1, or perhaps another way to get my answer I'm not thinking of?
Thank you!
