Forum Discussion
Excel Spilling Formulas and Can't Delete and No Array Found in Edit-Go Special - Going Crazy
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 Replies
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) )
PeterBartholomew1 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
