Today’s author is Bob Umlas, an Excel MVP since 1994. This tip is a formula which enables you to access a list of values interspersed with zeros or blanks and pick up only the non-zero values in the same sequence they’re listed. It’s better to illustrate. Suppose you have this list in A1:A14: …and you want to produce this list: The following formula entered in E1 and filled down to E6 does the trick. It’s an array formula which means that you must press Ctrl+Shift+Enter after entering the formula
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/06/30/formula-to-access-a-list-of-values-interspersed-with-zeros-or-blanks.aspx
Posted
Jun 30 2009, 03:00 AM
by
Microsoft Excel