MurdochQuill
Board Regular
 Joined
 Nov 21, 2020
 Messages
 84
 Office Version

 365
 Platform

 Windows
Hi all,
I have another question regarding =LET.
I currently use this let formula
This works fine when I fill down. I'm wondering how to change "F2" in this formula to reference the current row, and to also make this formula spill according to my global variable "MaxRows"
EG, the formula should then cover from G2:G52 (As the value of MaxRows is 52).
For future reference, could someone run through the steps to make it do this? I'm still not quite understanding how to make it work each time.
I have another question regarding =LET.
I currently use this let formula
Excel Formula:
=LET(Drng,'Sheet1'!$A$1:$A$20,Rng,F2,IF(SUM((Drng<>"")*(ISNUMBER(MATCH("*"&Drng&"*",Rng,0)))), "Y", "N"))
This works fine when I fill down. I'm wondering how to change "F2" in this formula to reference the current row, and to also make this formula spill according to my global variable "MaxRows"
EG, the formula should then cover from G2:G52 (As the value of MaxRows is 52).
For future reference, could someone run through the steps to make it do this? I'm still not quite understanding how to make it work each time.