Trying to Filter and display last 10 results

Question

I am trying to retrieve the last 10 mentions of the text that's in cell B8.

For example, if B8 is "Tom Brady", I want to retrieve the last 10 results for Passing Yards (DB:M) that mention Tom Brady.

I got this formula but it displays the first 15 it seems. =QUERY(DB!B:AZ,"select M where C = '"&B8&"' order by B desc limit 15")

Any help would be appreciated!

player0 · Answer

use:

=INDEX(SORT(SORTN(FILTER({D5:D, ROW(D5:D)}, D5:D<>""), 10, 0, 2, 0), 2, 1),,1)