unable to filter by specific data on a column if the rows exceed 1
 

i have data in 2 columns which exceed 1000 rows. In third column i compared
the first column with 2nd column using vlookup command. I have #N/A value in
some cells of 3rd column which started appear above 1000 rows ( till first
1000 rows in 3rd column had some data ) when i did filter the 3rd column and
wanted to see #N/A content, but i didnot get that at all. If i had #N/A in
below 1000 rows at 3rd column it appear in the drop down list of filter
option. it need to be corrected

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions