Excel Spilling Formulas and Can't Delete and No Array Found in Edit-Go Special - Going Crazy

[Chris_Hunter]

My problem:  Per the screenshot below, I seem to have an array that I can't locate and don't recall creating.  I can't seem to delete and cutting columns or inserting columns doesn't fix.  Frustrating.  If I "cosmetically" attempt to fix by having K46 =K45 I get a Spill Error in J46.  Error only happens when I put the ISTEXT(E46:I46) formula together.  How do I resolve?  Driving me nuts.  Chris Hunter, Farmington, NM

[#2]

@Chris_Hunter 

You appear to have tested the contents of 5 cells so you should expect to get 5 answers, each comprising the message or the sum.  This would be true for either a CSE array or a spilt dynamic array.

To get a single result combine the Boolean array using OR

= IF( OR( ISTEXT(array) ), "Error message", SUM(array) )

[#3]

@Peter Bartholomew   Thank you so much!  Couldn't find documentation on this issue anywhere and really appreciate your timely accurate response.  Formula works.

Chris Hunter
Farmington, NM