determining parent of leaf node in Multilevel Hierarchy

KkT

Hello Community, I need your help, i have to determine the Parent (FS Item) of each GL code in a chart of accounts however the leaf node can occur at any point in the hierarchy, so for example Parent of GL2 is Parent H and Parent of GL1 is Parent E. In each case i need the data 1 Level up from the leaf node. Please find attached the example file.

Thank you

example file.xlsx

KkT

thank you so much @atcodedog05   🙂 i really appreciate your super quick response!I am adapting this and will let you know how it goes!