Indexing Help with Children rows.

Christopher Daniel

I have a sheet that is using parent and children rows. I want the parent cell to always show the value of the top most row in its child section . The formula I am using is =Index([Sample]31,1,1) . When I add a new row to this section the formula changes to =index([sample]32,1,1). I need the reference row to remain 31. I have tried to add $ in front of it and this did nothing. Any Ideas.

L_123

if you want to get the first result try this:

=index(children(),1)

Christopher Daniel

Yep this worked.  Not sure why that never occurred to me.  Thank you for the help.