Hey guys,
I've got this weird problem...
Formula 1:
Formula 2:Please Login or Register to view this content.
Both are array formula.Please Login or Register to view this content.
formula 1 works fine
formula 2 is almost identical BUT fails. it will bring me one of the right results if i DO NOT use the array. I need to make it in a array so more than 1 result can be provided. (ctrl-alt-enter).. the second i make an array, results disappear.
I know where the error kicks in
Because if i change the M:M back to formula 1, suddendly the array works. But not if i add >1<=3 and ctrl alt enter it.Please Login or Register to view this content.
It is like it does understand my logical value, but loose it when i transform it in an array.
Any clues?
Bookmarks