convert r1c1 to a1 formula

[raptor_k7]

Is there anyone who can help me to convert the the following VBA code to regular Excel Formula(A1)?

"=INDEX((INDIRECT(R3C &""!$A$6:$A$1700"")),MATCH(LARGE(INDEX((INDIRECT(R3C &""!$E$6:$E$1700""))+(ROWS((INDIRECT(R3C &""!$E$6:$E$1700"")))-ROW((INDIRECT(R3C &""!$E$6:$E$1700""))))/10^5,0),ROWS(R1:R[-3])),INDEX((INDIRECT(R3C &""!$E$6:$E$1700""))+(ROWS((INDIRECT(R3C &""!$E$6:$E$1700"")))-ROW((INDIRECT(R3C &""!$E$6:$E$1700""))))/10^5,0),0))"

Thanks in Advance!

[romperstomper]

It depends which cell it's in.

[raptor_k7]

It depends which cell it's in.

Please find attached working file. I have recorded a Macro, it was working perfectly, Now I Couldn't get back to the regular A1 notation formula in B4:D18 as i'm getting error in the vba code.
Intended to identify the top 15 students in each exam based on their Total Marks along with other criteria. I couldn't recall it. Big Nightmare

I often use the below method to convert VBA code to A1 formula, but this time no luck.

https://learn.microsoft.com/en-us/of...convertformula

[Marc L]

Hi,

since the initial post I wanna say that the formula style no matters as both work …

The issue is you obviously did not check if your Excel version has the Formula2R1C1 property !
So replace it with the original FormulaR1C1 well working on my side with an older Excel version …
And once it works as expected you can see the classic formula style within the cell !
No need to convert anything as Excel does it natively …