=FILTER over merged cells a set range of cells, avoiding #SPILL! error.

[Marhier]

 

[Marhier]

Apologies - I hit the return key before finishing my post, and I can't figure out how to delete this

 

[Fluff]

You cannot use spill ranges in or over merged cells. Get rid of the merged cells they are an abomination & should be avoided like the plague.

 

[Marhier]

I thought as much.
I'd only used them as there is a table underneath it; I'll have to come up with another solution for the second table.

Apologies for the dual post - this one was created by mistake, and this board doesn't let you delete, or amend the title once you've posted; as mentioned in my first reply, I apologised and said what happened.

 

[Fluff]

Glad to help & thanks for the feedback.