Advanced Filter

  • Thread starter Thread starter nagaraj45
  • Start date Start date
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.
 
In the criteria area, use the same heading as the country column.
In the cell below, enter: <>India

Country
<>India
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot - Calculated field in row area 3
Copy Unique Record 2
Filter Data 2
Advanced Filter Help 3
counter in "If" condition 2
Report Filter 2
Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
Selecting examples from a table 6

Back
Top