Hi,

When i use If-Array formula to return me multiple values, I get th
desired result but the prob is that wherever the condition fails i
puts '0' (or Blank). for instance:

A3: Abc
A4: Xyz
A5: 0 (or Blank)
A6: EFG
A7: 0 (or Blank)

I need to have the data like below, if possible:

A3: Abc
A4: Xyz
A5: EFG (Note that A5 was previously showing 0 but this time it simpl
discarded 0 and moved the contents of next cell to this one)

is it possible

--
irresistible00