Forum Discussion
Copying Array Formulas
Poogermum But that's what the DA functions are all about. Enter them in one cell without the need to copy down/across. The #SPILL! error appears when there isn't enough space for the DA formula to display the result.
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.
Poogermum Not an expert on this particular function, but can't recreate what you describe. Can you upload an example file or a screenshot of what you are looking at?
