Filter Data
 

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.

Filter Data
 

Hi

Take a look at the sample workbook I created called FastFilter.
You can download it from Debra Dalgleish's site
http://www.contextures.com/Fastfilter.zip

--
Regards
Roger Govier

"Sivassou..." wrote in message
...
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.

Filter Data
 

On the button. Excellent Roger. Thanks much....

"Roger Govier" wrote:

Hi

Take a look at the sample workbook I created called FastFilter.
You can download it from Debra Dalgleish's site
http://www.contextures.com/Fastfilter.zip

--
Regards
Roger Govier

"Sivassou..." wrote in message
...
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.