Forum Discussion
Solved
Formulas wile working with few sheets information
Hi,,, below is an example of a work book I'm using, In this example I'm using 2 work sheets but normally it's more, in work sheet 1 I have information and in column 1 I have a formula been used, in s...
#SPILL! error
if it's not enough space (range wit blank cells) to expand the data by formula.
If we check next row(s)
there are some formulas or data in the next cells. Select and clean (Del) them to empty the space for the dynamic array, it works now
In addition, since you use formulae like =if(A3="WT C",A3:A4,"") it looks like you are on Excel 365, or at least 2021. If so why don't to use dynamic arrays more extensively, e.g. fo the beginning in I22
=IFERROR(
FILTER(
CHOOSECOLS('items '!$A$2:$Q$600, {1,3,4,17} ),
'items '!$A$2:$A$600 = $I$20 ), "" )and so on
So far your reply works best on my phone, tomorrow ill be trying it on my sheet on my work book and I'll let you know