| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif w/semicolon separated values
I have aggregated data in columns that were imported from web forms and are
separated by semicolons. The questions was select your preferred day of week with a select all that apply option. Any time someone chose more than one day, it aggregates the response together in the same cell (ie choosing Monday and Thursday returned a response of "Monday; Thursday" in B1...etc.) I want to be able to count each instance of Monday regardless of what other days per response. Monday - Total Tuesday - Total Wednesday - Total Thursday - Total Friday - Total. Below is a sample of data. Please help me! Thanks you. Wednesday Monday; Tuesday; Wednesday; Thursday Tuesday; Thursday; Friday Tuesday; Wednesday; Thursday Monday Monday; Tuesday; Wednesday; Thursday Thursday Tuesday; Wednesday Tuesday; Wednesday; Thursday Tuesday; Wednesday; Thursday Monday; Wednesday; Thursday Monday; Wednesday; Friday Tuesday; Friday Thursday Monday; Wednesday Tuesday; Wednesday |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to I create a comma separated values file | Excel Discussion (Misc queries) | |||
| table of # of rows with unique combos of values in 4 separated col | Excel Worksheet Functions | |||
| CONCATENATE on separated values | New Users to Excel | |||
| How to get values separated with / | Excel Discussion (Misc queries) | |||
| Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
Threaded Mode
