I came up with 1/2 a solution. I added the list of filenames (to the
filename row in Excel) and then sorted by filename. Now, everytime
there's a partially blank line, I know to delete both (the line above
it and the partially blank line). Still, that's 800+ manual
deletions.

Is there anyway to filter "duplicate" entries of a particular column?
I tried filter / custom; but, all I came up with was the ability to
filter by something from a drop down list. How do I filter by
"duplicate" entry in a certain column?


--
mirdonamy
------------------------------------------------------------------------
mirdonamy's Profile: http://www.excelforum.com/member.php...o&userid=30348
View this thread: http://www.excelforum.com/showthread...hreadid=500059