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 |
If false skip to next
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 |
All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com