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