Today’s author is Bob Umlas, Excel MVP and author of This isn’t Excel, it’s Magic, a book that is filled with tips and tricks for getting the most out of Excel. This post shows you how to quickly remove zero values and blank cells from a list that contains values. Here’s a formula which enables you to access a list of values interspersed with zeros or blanks and it will 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
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/09/01/remove-zeros-and-blanks-from-a-list-of-values.aspx
Posted
Aug 31 2009, 10:41 PM
by
Microsoft Excel