Determine LARGE with most recent data point excluded

That is getting very close. I've tested that within my sheet and it gets close but I have a few more equation constraints that cause it not to work.

I've put together a sample test sheet here with a data layout that is close to what I'm using in my original model. The highlighted portion is the formula that I need. The other data is laid out and has constraints similar to my original spreadsheet (which is massive and has some sensitive data so don't want to simply attach it).

And for reference (since I know this will come up), in the actual sheet I am looking for the Top 8 of 12 entries (we have an event each month). Sorry to confuse that, I was trying to simplify the problem earlier but it didn't provide the best info in retrospect.

I've also scanned this to ensure that it is virus-free, so no issues. I greatly appreciate your help!