Filter Data

[Sivassou...]

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.

 

[Roger Govier]

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

 

[Sivassou...]

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