How do I count occurences of data entered in a column??
Simon,
no need for VBA programming here. Just use "Countif" function in excel. If
you need the whole column A, for example, use this:
=countif ("A:A","Yes")
=countif("A:A","No")
Best
RADO
"ssr" wrote in message
...
Hi there can anyone help me out here.....
I am creating an app that has a column, say A, where "Yes"
or "No" can be selected from a list for each row of data entered.
Therefore
column A will be populated
with an infinite number of "Yes" and "No" in no particular set order.
I firstly need to calculate how many times "Yes" occurs for column A and
how
many times "No" occurs in that same column (A).
Once I have determined this I need to know the total amounts of times the
"Yes" + "No" has occured in column A.
After I have this information I then need to calculate percentages of the
"Yes" and "No" occurences which I think I can handle.
If it makes it easier I can send the file - and thanks in advance for any
help!
Simon
|