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 function


"allen367" wrote in message
...
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 "data contains non-numerice input". Does that
mean all data has to be converted to nummerical format?