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.
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.