Forum Discussion
jemenake
Dec 08, 2021Copper Contributor
Setting cells to default to mixed/absolute referencing
I googled around, but couldn't find an answer to how to do this (but, at the same time, I can't believe that this hasn't been requested enough that Microsoft hasn't put it into Excel, yet). I mak...
JKPieterse
Dec 08, 2021Silver Contributor
jemenake You can also use dynamic arrays, like shown in the attached Excel file, which contains no more than 3 formulas!