![]() ![]() My main concern here is that the non-zero values look like text values, and Excel always treats text values as text, even if they only contain numerics. The column now looks like this, and contains only numeric values and no formula: I then used an IF function to output 0 when an Age cell is blank, and I copied the function output column, then pasted values, to ensure nothing could think the new column contained anything non-numeric. I tried to use the Data Analysis Toolkit add-in to get Descriptive Statistics for the Age column, but got a message that the column contains non-numeric data. I have an Excel column that had a list of ages, with several empty cells more or less evenly distributed along the column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |