04-Jun-10
12-01-2010, 12:39 PM
Hi All,
I Hope you all could help me on this.
As you could see in attached xls file, I need to filter out only those columns which have their string value as "john".
Autofilter can be applied if the complete string is "john". But here its a part of string and so I couldn't do it with autofilter option. Is it possible to apply autofilter in this scenario? If not, could you please guide me on how to apply this functionality?
Thanks,
Madan
I Hope you all could help me on this.
As you could see in attached xls file, I need to filter out only those columns which have their string value as "john".
Autofilter can be applied if the complete string is "john". But here its a part of string and so I couldn't do it with autofilter option. Is it possible to apply autofilter in this scenario? If not, could you please guide me on how to apply this functionality?
Thanks,
Madan