If false skip to next

Hi,

When i use If-Array formula to return me multiple values, I get the
desired result but the prob is that wherever the condition fails it
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 simply
discarded 0 and moved the contents of next cell to this one)

is it possible ?


--
irresistible007


------------------------------------------------------------------------
irresistible007's Profile: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2311630

What is the array formula doing? Data and requirements.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"irresistible007" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> When i use If-Array formula to return me multiple values, I get the
> desired result but the prob is that wherever the condition fails it
> 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 simply
> discarded 0 and moved the contents of next cell to this one)
>
> is it possible ?
>
>
> --
> irresistible007
>
>
> ------------------------------------------------------------------------
> irresistible007's Profile: http://www.hightechtalks.com/m63
> View this thread: http://www.hightechtalks.com/t2311630
>