As JB says, it's an array formula, but not because of StringConcat; it's because of this part:
=StringConcat(",", IF(B5:B9>0, A5:A9, "") )
... because the IF has to evaluate an array and return an array.
As JB says, it's an array formula, but not because of StringConcat; it's because of this part:
=StringConcat(",", IF(B5:B9>0, A5:A9, "") )
... because the IF has to evaluate an array and return an array.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks