title: Create New List of Duplicate Values in Excel Based on Criteria
body: <p>I have a spreadsheet of data that has a column for "Cost Category" and a column for "Vendor Name" among others. I need to create a list of all the unique vendors that fall into the cost category of labor.</p>
  
  <p>This question is partially answered by the question at the following link: <a href="https://stackoverflow.com/questions/13307927/ignore-duplicates-and-create-new-list-of-unique-values-in-excel">Ignore Duplicates and Create New List of Unique Values in Excel</a></p>
  
  <p>The formula in that link creates a list of unique vendor names but I cannot figure a way to make the formula only source from vendor names that fall into the Labor cost category.</p>
  
  <p>I need to accomplish this with a formula rather than with VBA because results in the new list will be used to populate other sheets within the document to drill down into additional data.</p>
  
  <p>Thanks for the help!</p>
  
  <p>Update: I've included a link to a google doc with a set of sample data. I hope this helps. <a href="https://docs.google.com/spreadsheets/d/1SofyLcIxnglQgojNP7YxjkS9kJrfp35qA2Y7nE2PZoo/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1SofyLcIxnglQgojNP7YxjkS9kJrfp35qA2Y7nE2PZoo/edit?usp=sharing</a></p>