RANK.EQ & Filter Query

[LNFFL]

Hi,

I'm converting a Google Sheet into Excel and having an issue with a formula and wondering if someone can help me out.

I have two columns (F & G) containing the main data and two columns (N & O) containing Year & Week No.

The Google sheet has two columns with formulas to rank the values in F & G:

=rank(F2,filter(F:G,N:N=N2,O:O=O2))
=rank(G2,filter(F:G,N:N=N2,O:O=O2))

I'm trying to replicate it in Excel 365 by doing the following =RANK.EQ(F2,filter(F:G,N:N=N2,O:O=O2)) but having no joy.

Any input would be greatly appreciated.

Thanks in advance.