LARGE function adjusted for filtered subtotals

[Hieronymus5]

Excel Problem 1.xlsx

Dear All,

I am having some issues with the LARGE function in conjunction with filters. In the Excel file provided, I want to rank the company past year returns from largest to smallest. However, while doing this I want to filter on Fiscal Year so I can check the ranking of returns per Fiscal Year.

I already got a formula from some forum (Mr. Excel?) but clearly, it doesn't work for me. Since I do not fully grasp (if, at all) the ranking formula in the workbook, I do not know why it returns an error and what to correct.

If anyone could help me with this I would be eternally grateful! (Well, probably for a few weeks anyway)

Regards,

Hieronymus5