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"
wrote in message
...

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