title: Microsoft Excel Spreadsheet filter with cells with multiple values
body: <p>We all know how the auto filter of Excel spreadsheet works: once the auto filter is turned on, a list of distinct values from each cell of a column shows with a checkbox in front of each value. </p>
  
  <p>I am trying to find out if it is possible for one cell to have more than distinct one value and each of them still shows in the auto filter list so that when any one of them is selected in the auto filter, the row with this cell will be selected.</p>
  
  <p>For example, I have a column called "developers". One of the cells of the column has two names, "John, Smith".  What should I do so that Johnn and Smith would appear in the auto filter select list, when either John or smith, or both are selected, the row with this cell will be in the result set.</p>
  
  <p>Thanks.</p>