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")