software

I have a survey which has some text answers and some numerical answers. I
need to complete histogram and descriptive statistics on this data but I get
an error message stating my quot;data contains non-numerice inputquot;. Does that
mean all data has to be converted to nummerical format?

one way to solve theproblem use count if

suppose non numeric data for e.g. a.s.d.f.g etc are in A1 to A100
find out unique set by using advance filter
and then use countif functionquot;allen367quot; gt; wrote in message
...
gt; I have a survey which has some text answers and some numerical answers. I
gt; need to complete histogram and descriptive statistics on this data but I
get
gt; an error message stating my quot;data contains non-numerice inputquot;. Does that
gt; mean all data has to be converted to nummerical format?