| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I count occurences of data entered in a column??
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text occurences in range when criteria in other column is me | Excel Worksheet Functions | |||
| How do I count the # of unique occurences of a text in a column? | Excel Worksheet Functions | |||
| count text occurences in a column | Excel Discussion (Misc queries) | |||
| formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
Threaded Mode
