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