ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating a column of numbers from a column with some blanks? (https://www.excelbanter.com/excel-discussion-misc-queries/78337-creating-column-numbers-column-some-blanks.html)

Knut

Creating a column of numbers from a column with some blanks?
 
I need to graph data from a column that includes some blank cells, but I do
not want to show the blank (or "0") numbers in the graph. How can I create a
column of all non zero values from a column with some zero values? The
created column will clearly have less entries than the starting one.


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com