See attachment
To turn on autofilter:
Tools - Filter - Autofilter
Click on the helper column drop down list and select:
custom - does not equal & #N/A
This will only show all rows where the value under helper column does
not equal #N/A. These should be what you want to delete
Highlight all visible rows, press F5 and choose:
special - visible cells only - OK
Now delete these rows
+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4270 |
+-------------------------------------------------------------------+
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=505319