CODE function bug in dynamic array formula?

[David Whitney]

This one has me banging my head on the desk. I am passing a stick of ANSI characters to a formula. That formula converts those chars to codes. It worked yesterday, now it fails in the strangest way -- the CODE function returns the ANSI code of the first number in the character's ANSI code, i.e. A through E return 54 because "6" is the first number in their ANSI code. It get worse. When I HSTACK the character and code arrays the codes are perfect. But when I drop the character column the codes go to hell again.

NOTE this does not happen in the grid, only inside my custom formula. Thanks for looking and I hope this isn't happening to anybody else today.

 

[Fluff]

That formula converts those chars to codes

What is the formula?

 

[David Whitney]

What is the formula?

CharArray is a vertical stick of ANSI characters. The highlighted line is where the problem occurs. It's supposed to give me 1s and 0s for matching/non-matching characters.

 

[Fluff]

Can you post the entire formula, debugging an image is not easy.

 

[David Whitney]

ROFL I found the problem. There is no bug.

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[David Whitney]

Glad you sorted it & thanks for the feedback.

Thanks for the attention. I never solved it completely. This formula has run successfully hundreds of times. I pass several arrays of chars one a time and it is only unhappy with one. I worked around it by passing that one array using CHAR of the desired codes instead of pulling a character column from another output like I do for every other iteration. Quick fix but it's a kludge. I can not for the life of me figure out what is different about this one array that worked until I got my most recent Office update. It's like it's got a hidden column that makes Excel think I'm trying to do an operation on an array of arrays. The output mimics that symptom. I did a CONCAT of the char and code columns and Excel displayed the character once followed by the code twice -- that's not supposed to be possible.