I have Excel columns with different statements (yes, no; numbers).
I keep membership records on Excel. Some of the columns include things like
"Yes" and "No". Others are codes (e.g. for ethnicity - 1 to 9). I need to
produce statisitics every quarter, analysing these columns. I can do this by
hand but is there a way of doing this in Excel. E.G. for ethnicity "1" has 4
records; "2" has 1 record etc.
|