Advanced Filter

[nagaraj45]

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]

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

Country
<>India