Find last MATCH for each row on a 2D running array with ONE "spill" formula

Here I come again with another 2D array formula curveball (at least for me...)

Below is a short snippet of a particular column within a multi-column table containing a list of stock tickers:

Data.png

Then I went through the usual motions to get to a 2D "spill" formula down and across for the above range, which is to TRANSPOSE a UNIQUE list of all tickers, and then put together a cumulative 2D array of said column - which I picture below along with the respective formula:

Formula:

Please Login or Register  to view this content.

Data_*** Array.png

And when I finally get to the point of reaching my goal, which is to extract the last row number that matches each respective ticker on the transposed list (as pictured below), I'm stuck with a 1D solution using a previously provided BYROW approach from Bo_Ry on a different question I had.

Formula:

Please Login or Register  to view this content.

Match_1D_Array_Formula.png

The above solution again needs to get dragged across columns, and I need a dynamic solution that will stretch down and across since not only the table feed will grow, but also new tickers will for sure come up in the future...

Any way I could adapt that to my needs?

Thanks in advance...

P.S.:
I've also posted this same question on Microsoft Tech Community.

HTML Code: 

How about

=LET(c;$C2#;sr;SEQUENCE(ROWS(c));cc;COLUMNS(c);--MID(BYCOL(X1#;LAMBDA(z;CONCAT(TEXT(MOD(SMALL(sr*1000+SEQUENCE(;cc)*(c=z);sr*cc);1000);"00"))));sr*2-1;2))

Originally Posted by Bo_Ry

How about

=LET(c;$C2#;sr;SEQUENCE(ROWS(c));cc;COLUMNS(c);--MID(BYCOL(X1#;LAMBDA(z;CONCAT(TEXT(MOD(SMALL(sr*1000+SEQUENCE(;cc)*(c=z);sr*cc);1000);"00"))));sr*2-1;2))

Hey Bo_Ry, thanks again for this very nimble solution you provided... but when I tried to apply that to my actual full schedule, which contains more than 100 rows, it won't work because I noticed your solution "resets" the rows count every 100 rows (i.e.: it returns row 42 instead of row 142).

I tried to fix that by adding a couple more zeroes to your calculation, tested first on my mock up data just to make sure I wouldn't screw up anything, but then when I applied to my real data this reset continues.

What am I missing here?

Try

=LET(c;$C2#;sr;SEQUENCE(ROWS(c));cc;COLUMNS(c);--MID(BYCOL(X1#;LAMBDA(z;CONCAT(TEXT(MOD(SMALL(sr*1000+SEQUENCE(;cc)*(c=z);sr*cc);1000);"000"))));sr*3-2;3))