Spreadsheet: 746538d1630826435-find-last-match-for-each-row-on-a-2d-running-array-with-one-spill-formula-2d-spilled-range-find-last-match-for-each-row
Sheet: 2D Spilled Find Last Match, Row

Stock ticker |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B3SA3 | BBAS3 | BBDC4 | BOVA11 | HASH11 | M1RN34 | SMAL11 | TSLA34
BBDC4
BBAS3 |  | BBDC4 | BBAS3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0
BBAS3 |  | BBDC4 | BBAS3 | BBAS3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0
BOVA11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 0 | 0
SMAL11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 5 | 0
SMAL11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 6 | 0
SMAL11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 7 | 0
TSLA34 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 7 | 8
TSLA34 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 7 | 9
HASH11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 10 | 0 | 7 | 9
HASH11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 11 | 0 | 7 | 9
HASH11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 12 | 0 | 7 | 9
BBAS3 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 |  |  |  |  |  |  |  |  | 0 | 0 | 13 | 1 | 4 | 12 | 0 | 7 | 9
BOVA11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 |  |  |  |  |  |  |  | 0 | 0 | 13 | 1 | 14 | 12 | 0 | 7 | 9
BOVA11 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 | BOVA11 |  |  |  |  |  |  | 0 | 0 | 13 | 1 | 15 | 12 | 0 | 7 | 9
B3SA3 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 | BOVA11 | B3SA3 |  |  |  |  |  | 0 | 16 | 13 | 1 | 15 | 12 | 0 | 7 | 9
TSLA34 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 | BOVA11 | B3SA3 | TSLA34 |  |  |  |  | 0 | 16 | 13 | 1 | 15 | 12 | 0 | 7 | 17
APER3 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 | BOVA11 | B3SA3 | TSLA34 | APER3 |  |  |  | 18 | 16 | 13 | 1 | 15 | 12 | 0 | 7 | 17
M1RN34 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 | BOVA11 | B3SA3 | TSLA34 | APER3 | M1RN34 |  |  | 18 | 16 | 13 | 1 | 15 | 12 | 19 | 7 | 17
M1RN34 |  | BBDC4 | BBAS3 | BBAS3 | BOVA11 | SMAL11 | SMAL11 | SMAL11 | TSLA34 | TSLA34 | HASH11 | HASH11 | HASH11 | BBAS3 | BOVA11 | BOVA11 | B3SA3 | TSLA34 | APER3 | M1RN34 | M1RN34 |  | 18 | 16 | 13 | 1 | 15 | 12 | 20 | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ↑ Last row # match for each respective stock ticker from cumulative 2D array ↑
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 6 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 7 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 0 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 10 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 11 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 1 | 4 | 12 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 13 | 1 | 4 | 12 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 13 | 1 | 14 | 12 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 13 | 1 | 15 | 12 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 16 | 13 | 1 | 15 | 12 | 0 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 16 | 13 | 1 | 15 | 12 | 0 | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 16 | 13 | 1 | 15 | 12 | 0 | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 16 | 13 | 1 | 15 | 12 | 19 | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 16 | 13 | 1 | 15 | 12 | 20 | 7 | 17