Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Using returned values as part of another formula | Excel Worksheet Functions | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
How to sum values in multiple worksheets | Excel Worksheet Functions |