Either this time I will talk about some of the ancillary techniques under filter, although not that critical, but still once in a while, you may want to use this in 2007 version of Excel they came out with a color based filter. So if I choose the data and I apply a filter, I will have the option under the drop down which will say filter by color. So, if I choose the orange one, notice all the orange cells the ones which had colored in the orange color have been filtered out. So, I can go back and say clear filter from location. Another technique which is part of the text filter, you will find that in the drop down line name, let's assume that you want to pick up those names which contain which contain meals and the word PVD private. So, I go to text filters and I choose contains and I choose PVT contains PBT and at the same time it should contain mil mil.

Okay, so I'm getting just one name which contains mil and the word private. So there you go. These are just some of the simple unfiltered tricks under filter tab. Thank you