title: Excel create list of names, excluding name selected from drop down list
body: <p>I am new to more advanced excel formulas. I have an issue with what I think should be pretty basic functionality, however I have not found an applicable answer.</p>
  
  <p>Worksheet2 has a list of 10 distinct names. Worksheet1 (B2) has data validation drop-down list populated with the names in Worsheet2.  I want to copy the list of names from Worksheet2 (starting in cell B4), excluding name selected from drop-down list.</p>
  
  <p>Any advice would be appreciated.</p>