Forum Discussion
Formulas wile working with few sheets information
#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
SergeiBaklan thank you for your reply but I'm having bother, I have tried using your fourmla as you have and each time I keep getting "Spill" even tho I am copping your fourmla exactly and iv compared both and are both the same. Any ideas. Bellow I have attached the sheet,
#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
Norman_Glenn , you are welcome
- Sorry for the delay but thank you so much for your patience and help great help thank you.