Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,113
- Office Version
- 365
- Platform
- Windows
Hi All,
I am working with Excel 2013 & I want to 'Advance Filter' with more than one Criteria in a Cell w/o 'Advanced Filtering' for a 2nd time based on another criteria in further reducing the produced list.
ie.
Criteria:
<tbody>
</tbody>
Now, if I want to also omit another name w/o Advance Filtering for a 2nd time, for example, to further omit <>Michael; How can I do this in its original cell?
Is there a way to join in that original criteria cell, <>Charles & <> Michael?
Many Thanks,
-Pin
I am working with Excel 2013 & I want to 'Advance Filter' with more than one Criteria in a Cell w/o 'Advanced Filtering' for a 2nd time based on another criteria in further reducing the produced list.
ie.
Criteria:
Name | Number |
<>Charles | |
<tbody>
</tbody>
Now, if I want to also omit another name w/o Advance Filtering for a 2nd time, for example, to further omit <>Michael; How can I do this in its original cell?
Is there a way to join in that original criteria cell, <>Charles & <> Michael?
Many Thanks,
-Pin