0 Replies Latest reply on Jul 18, 2012 1:09 PM by Xiaorong Li

    How to create a filter that shows the results based on multiple selections?

    Xiaorong Li

      Hi,

       

      I have a question about How to create a filter that shows the results based on multiple selections. In the attached workbook, for example, I want to search for phones that have both MIDI and MP3 features. When I click 'MIDI' and ctrl+click 'MP3', the results returned with phones that have either MIDI OR MP3 feature. But what I want is just those phones that have both features (in this case, G101, G101i, and G111). How can I do that? Any ideas will be highly appreciated. Thanks!

       

      Xiaorong