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

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