Hi
Maybe the easiest way would be to mark your range B2:L2
DataFilterAutofilter.
Use the dropdown to select either 0 or 1 as required.

Regards

Roger Govier


TeachCTC wrote:
I have a simple table with student names in B2:L2 and words in A2:A221.
Under each student name next to the word, I put a 1 if they knew the word or
a 0 if they did not.
Question: Can I have the students name returned if they had a 0 in the box
for a particular word? Example: In A2 the word is 'the'. Under student A I
entered a 1, under student B a 0, and student C a 0, etc. I want a formula
that will return each name that has a 0 for that word.