title: Returning a list of column Headers when the row value is zero
body: <p><a href="https://i.stack.imgur.com/vfrY2.png" rel="nofollow"><img src="https://i.stack.imgur.com/vfrY2.png" alt="enter image description here"></a></p>
  
  <p>I have several tables in excel similar to the image. Each row is labeled with a student name and the column headers are words they are tested on. The cell values are 1 for a correct answer and zero for incorrect. What I want to do is, in a separate sheet, list the words each student missed. I need a function that will return the column header for each 0 in the row with a given student name. I need a single function that will return every missed word per student. </p>
  
  <p>What I want is a function like: "for('Given student Name, in given table'), list all missed words". 
  The output would look something like:</p>
  
  <p>Name1 Name2 Name3 Name4</p>
  
  <pre><code>        on    and
  
          this  on
  
                the
  
                this
  </code></pre>
  
  <p>I cant use VBA for this. </p>
  
  <p>Thanks for any help you can provide. </p>