Calculating Yearly Account Growth by Account in an Unsorted Worksheet

First idea would be to sort the data, or make a copy of the data and sort that by account and then by year.
If the data absolutely can not be sorted, as modeled in columns J:M where the data is listed ascending by year (just a guess):
Second idea is to make a sorted result table (by account then by year) as modeled in columns O:P
Columns Q:R are populated using: =AGGREGATE(15,6,L$3:L$26/($J$3:$J$26=$O3)/($K$3:$K$26=$P3),1)
Columns S is populated using: =IF(O3<>O2,Q3,S2*(1+R3))
If this isn't applicable then please upload some data that is representative of the unsorted state with which you will have to work along with expected output.
Let us know if you have any questions.

Using a CAGR formula maybe as in the attached.