In excel i'd use the countif function to do this. If there was a list of
all the teachers in column A, and a list of some of them in column C, then
=countif(A1,C:C) would return a 1 if the teacher in A1 was in the list in
column C, and a 0 if he's not. So put that in B1, then copy to all cells
in column B that have names in column A. Of course, you have to spell
the teacher's name exactly the same in both lists...
If you want to see yes/no rather than one/zero, or anything else, you just
wrap the if function around this.
I don't know if you can do this in Google spreadsheets.
Brattleboro Union High School District # 6
School Information Technology Discussion <[log in to unmask]> writes:
>I'm looking for a solution to a Google Forms issue.
>The principal has a form that collects data regarding teachers'
>attendance at extra-curricular events. (The teachers fill it out.) My
>goal is to find a way that allows the principal to see who has not yet
>filled the form out more quickly than searching the spreadsheet. Is there
>a script that compares the collected data to a list of the individuals
>who need to fill the form out? Is there another way that we could get
>St. Albans City School
>St. Albans, VT 05478
>Blog: [ http://mrallenslearning.blogspot.com
>"Everybody is a genius. But if you judge a fish by its ability to climb
>a tree, it will live its whole life believing that it is stupid." Albert
>CONFIDENTIALITY NOTICE: The information contained in this transmission Is
>privileged and confidential information intended only for the use of the
>individual or entity named above. If the reader of this message is not
>the intended recipient, you are hereby notified that any dissemination,
>distribution, or copying of this communication is strictly prohibited. If
>you have received this transmission in error, do not read it. Please
>immediately reply to the sender that you received this communication in
>error and then delete it. Thank you.