Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency of occurence
I am looking to find the most frequent occurrence of a text field in a row.
Example of the rows and columns: AZ Sais Supplemental Daily Attendance Daily Attendance Student Student Entry Special Education Student Entry Parent/Guardian Parent/Guardian Student Student Daily Attendance Sibling Location Parent/Guardian Parent/Guardian Emergency Emergency Emergency Emergency Sibling Location Immunization Discipline Sibling Location Student Entry Student Health Phone Numbers Special Education Special Education Student Entry Special Education Phone Numbers Period Attendance AZ Sais Supplemental AZ Sais Supplemental AZ Sais Supplemental Phone Numbers Student Classes Sections Discipline I am trying to find the most common item for row one, then row two, then row three.... The end result is to find a template for 32 different schools that causes the least disruption for each school but standardizes the order of the process across all 32 schools. Bob Weeden |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Frequency of occurence
1. change yor data from rows to columns and use a header cell
the first column would look like: words AZ Sais Supplemental Daily Attendance Daily Attendance Student 2. create a pivot table using Count of words in the data field, should see: Count of words words Total Attendance 2 AZ 1 Daily 2 Sais 1 Student 1 Supplemental 1 Grand Total 8 Then the most frequent. -- Gary's Student "R Weeden" wrote: I am looking to find the most frequent occurrence of a text field in a row. Example of the rows and columns: AZ Sais Supplemental Daily Attendance Daily Attendance Student Student Entry Special Education Student Entry Parent/Guardian Parent/Guardian Student Student Daily Attendance Sibling Location Parent/Guardian Parent/Guardian Emergency Emergency Emergency Emergency Sibling Location Immunization Discipline Sibling Location Student Entry Student Health Phone Numbers Special Education Special Education Student Entry Special Education Phone Numbers Period Attendance AZ Sais Supplemental AZ Sais Supplemental AZ Sais Supplemental Phone Numbers Student Classes Sections Discipline I am trying to find the most common item for row one, then row two, then row three.... The end result is to find a template for 32 different schools that causes the least disruption for each school but standardizes the order of the process across all 32 schools. Bob Weeden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
Frequency of occurence | Excel Worksheet Functions | |||
Frequency for Histograms in Excel | Charts and Charting in Excel |