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

Advanced Filter
 

In the criteria area, use the same heading as the country column.
In the cell below, enter: <India

Country
<India


nagaraj45@sify. wrote:
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.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html