Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell Data Filter Fails to Integrate New Data-rows Richard-44 Excel Discussion (Misc queries) 2 November 10th 07 03:30 AM
Excel 2007 Data Filter - When using cut it clears all data SEF Excel Discussion (Misc queries) 2 June 20th 07 04:10 PM
in data/filter/auto filter sp8 Excel Worksheet Functions 2 May 12th 06 01:03 AM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM
How to filter and list data based on different data. Defoes Right Boot Excel Worksheet Functions 3 April 13th 05 04:03 PM


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"