Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
nagaraj45@sify.
 
Posts: n/a
Default Advanced Filter


I have the following worksheet.

Name Country

A India
B UK
C USA
D Germany

How to use *Advanced Filter *to extract data with Country not equal to
India. This is required to apply in some database functions like dsum.


--
nagaraj45@sify.
------------------------------------------------------------------------
nagaraj45@sify.'s Profile: http://www.excelforum.com/member.php...o&userid=32193
View this thread: http://www.excelforum.com/showthread...hreadid=519406

 
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
advanced filter BorisS Excel Worksheet Functions 1 January 13th 06 05:30 PM
refresh advanced filter results eagle Excel Discussion (Misc queries) 2 November 18th 05 09:15 AM
Using advanced filter to search for criteria in a list Potatosalad2 Excel Discussion (Misc queries) 1 June 8th 05 03:08 AM
Advanced Filter: No Filter Evan Weiner - Richalnd WA Excel Discussion (Misc queries) 2 December 9th 04 04:36 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM


All times are GMT +1. The time now is 10:36 PM.

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"