Can anyone answer a question: why is it that if I select a range, type a
formula which contains a relative reference, then hit ctrl+enter, the
reference contained in each cell will indeed vary according to its position
in the range. However, if I hit ctrl+shift+enter, to enter an array, all
cells will contain the same literal reference I typed in. What is the
rationale here? Perhaps it would help me understand a bit more about arrays.