Array Formula Not Working with Range with Formulas
Although at the moment I am not in the position to understand what the
formula does, your problem seems to have to do with the values in ID6.
Check for space characters. They might exist in the source data so,
when you just type them they are not found, but when you Copy/Paste
they are.
Use the text functions =LEN(), =CODE(MID(A1,x,1)) to see if there are
any non-printing characters.
Does this help?
Kostis Vezerides
|