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. Frustratin...
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
