Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A does not work with Excel filter
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A does not work with Excel filter
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) wrote in message ups.com... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A does not work with Excel filter
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. wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter count does not work | Excel Discussion (Misc queries) | |||
Filter does not work | Excel Discussion (Misc queries) | |||
Why does this filter not work properly | Excel Discussion (Misc queries) | |||
Scratch that, using a filter did not work | Excel Discussion (Misc queries) | |||
Auto Filter will not work in a new worksheet | Excel Worksheet Functions |