I was able to get assistance with my previous group selection formula and it worked wonderfully. The problem is that they changed how the data is stored and now it is in text where it was numbers in the past. Let me give you an example of my data.
We are trying to find the "Perfect Days" in our evaluations. The way we do that is if everyone in our class gives us a perfect score of "Strongly Agree" and there are 4 or more people in a class. An example of our data is this:
Jack Black 4/10/2010 "Q1" Strongly Agree
Jack Black 4/10/2010 "Q2" Agree
Jack Black 4/10/2010 "Q3" Strongly Agree
Mary Beth 4/10/2010 "Q1" Neutral
Mary Beth 4/10/2010 "Q2" Agree
Mary Beth 4/10/2010 "Q3" Strongly Agree
.
.
.
There are 12 questions in all for each evaluation but I only want the first 9 because the last three are open-ended comment questions and will never equal "Strongly Agree." So does anyone have an idea how to do a group select that will look through the first 9 of 12 questions and let through only those that all have "Strongly Agree" and there are more than 3 students in a class? Thanks!
We are trying to find the "Perfect Days" in our evaluations. The way we do that is if everyone in our class gives us a perfect score of "Strongly Agree" and there are 4 or more people in a class. An example of our data is this:
Jack Black 4/10/2010 "Q1" Strongly Agree
Jack Black 4/10/2010 "Q2" Agree
Jack Black 4/10/2010 "Q3" Strongly Agree
Mary Beth 4/10/2010 "Q1" Neutral
Mary Beth 4/10/2010 "Q2" Agree
Mary Beth 4/10/2010 "Q3" Strongly Agree
.
.
.
There are 12 questions in all for each evaluation but I only want the first 9 because the last three are open-ended comment questions and will never equal "Strongly Agree." So does anyone have an idea how to do a group select that will look through the first 9 of 12 questions and let through only those that all have "Strongly Agree" and there are more than 3 students in a class? Thanks!