Forum Discussion
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...
jemenake You can also use dynamic arrays, like shown in the attached Excel file, which contains no more than 3 formulas!