Hi,

I am having Excel data in the following format:

A B C
Country State City
India TN Chennai
India TN Salem
USA FA Texas

When enter "India" in column E1, I want to get following results:

India TN Chennai
India TN Salem

Is there any built in fuction (Expect Advance Auto filter). Your help is
highly appreciated. Thanks.