FAO Glenn Kennedy maybe?

How can I convert this google sheet formula to excel?

The OP is using a FILTER function in Google Sheets but wants to convert to Excel 2016. I have seen clever stuff done with FILTERXML but it is not a strong point for me.


Thoughts and ideas would be appreciated from anyone/everyone.