How to filter list for missing fields

[djarcadian]

I have a list of people and their addresses. Some people have neglected to fill in their address information. How could I filter the list so it only displays the rows that contain all the information I need and then export that list to it's own Excel file.

[AlfD]

Hi!

Use Data > Filter > Autofilter.

Filter column-by-column (cumulatively) for Not Blank items.
Select the cells now showing. F5 > Special > Visible cells only. Copy and Paste Special where you want the list.

Alf