advanced filtering

  • Thread starter Thread starter jiwolf
  • Start date Start date
J

jiwolf

is it possible to use an advanced filter to find data that does not match a
condition?

for example, i have a file i need to filter that has one column that can
have a value of "k" or be empty. The filter easily finds those records that
have "k" in column c. How would i find those records that don't have a "k"
in them?

tia

peter
 
You must log in or register to reply here.

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

advanced filters 4
need help on either doing a loop and counting specific values orusing subtotal function 2
VBA to Filter on variable column 5
Compare 2 lists and return value 2
missing data w/ advanced filter 6
Filtering Using Values In A Specific Cell 3
Conditional Filtering 3
SUMIFS formula with 3 OR Conditions 3

Back
Top