Advanced Filter

N

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.
 
D

Debra Dalgleish

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

Country
<>India
 
Top