Home > other >  Trying to Filter and display last 10 results
Trying to Filter and display last 10 results

Time:09-23

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

enter image description here

  • Related