#N/A does not work with Excel filter


S

sheikhan

Hi,

I have data for about 5500 people and I an getting #N/A after I have
done a Vlookup and Now I want to filer the #N/A to print or examine
them.

1. Can I use a standard excel filter to filter out the #N/A 's, if so
then how.
2. If the standard filter does not work then how do i filter them out.

Thank you.
 
Ad

Advertisements

B

Bob Phillips

Filter works with #N/A for me, it is in the list of values, and I can select
it in the criteria.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Ad

Advertisements

D

Dave Peterson

Maybe....

The autofilter dropdown will show the first 1000 unique entries in that field.
But you can still use a custom filter (choose custom under the dropdown) and
then equals #n/a.
 

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


Top