If false skip to next

[irresistible007]

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

 

[Bob Phillips]

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]...