I need a new column in which I have the growth of the trees in my data. I have put a sample file for better understanding.
I need a formula that identifies the same trees (ID_Tree) then do the difference of size (ST_Tree) in chronological order. Meaning if a tree (ID_Tree) has been inventoried at a newer date (DATE) it needs to do the ST_Tree of the newest tree minus the ST_Tree of the tree just older than it. A Tree can be inventoried multiple time (up to 6 times). So the formula can't just do the newest minus oldest, because I would not see the evolution between the second and third inventory or the third and fourth.
Help_Growth_Trees.xlsx
Bookmarks