Forum Discussion
Copying Array Formulas
Hi yes I understand that this is what array functions are all about however, how do I make excel occupy the required cells with the formula in question?!?!
for example:
1. I type frequency (b1:b10,c1:10) into a cell and then press enter it automatically comes back with spill! even if there are lots of cells around the input cell
2. if I type the same formula and press shift/ctrl/enter, the formula is only displayed in one single cell but needs to be in a number of cells to show the full array!
I just don't know how to make it copy down the array to show all the results.
IMHO, both formulas shall return exactly the same. Regular returns array of 11 elements. with second one you select 11 cells and Ctrl+Shift+Enter to receive the same result.
Anyway, without the sample that's abstract discussion.