[edt]

Originally Posted by smason

I'm not sure the best answer, but a quick workaround in Excel is
select all, click data, filter, advanced filter and check the unique records only button.
I'll think all but one blank line is duplicate, and will filter it.
You can leave it filtered, or copy/paste it into a fresh sheet.

Thanks all for the advice. And thanks Don for fixing the problem so fast.