Is it possible to access the grouping level in an Excel formula

microsoft-excel

I have an Excel sheet that looks something like this:

enter image description here

Is it possible to write a formula which accesses the grouping levels (the numbers marked in red)?

The problem is that we have a piece of software which exports a BOM (Bill Of Materials) describing, in a top-down manner, the different articles contained in mechanical product. The grouping number is the only way to know which level a certain article is on.


Solution 1:

why not try VBA script of macro?

I think this will help: Worksheets("Sheet1").Rows(i).OutlineLevel

Go through the sheet and write this property into cells.

Related

ASUS T100TA - How I can install Windows 7
If named tmux session exists, make new session and group with it, else create that named tmux session
Cygwin dd of='\\.\PhysicalDrive0' Invalid argument
How to find the girth of a graph?
Quick question about inaccessible cardinals
Probability of the maximum of n binomial random variables being less than n
What does $g^1$ represent in group theory?
Show that $(a+b)^7-a^7-b^7=7ab(a+b)(a^2+ab+b^2)^2$
nonnegative complex numbers
Find all points on the XY plane where parabola doesn't pass
$\lim_{x\to 1}\ln(1-x)\cot\frac{\pi x}2$
Prove there exists $c\in\mathbb{C}$ such that $|c| \leq 1$ and $f(z)=ce^{z}$