Formula assistance

System

This discussion was created from comments split from: Locating the parent of a parent.

NeilKY

@Paul Newcome

Do you know of a way to make this work while using a formula that is "column formula compatible"?

The only one with an issue is the Row# =COUNTIFS(Level$1:Level@row, OR(@cell = "", @cell <> ""))

Paul Newcome

@NeilKY There is a column formula friendly method of creating the [Row #] column. First you insert an auto-number column (formatting doesn't matter). Then in the text/number column that will house the row numbers you use

=MATCH([Auto-Number]@row, [Auto-Number]:[Auto-Number], 0)