Automating Email Detection: Finding Missing Emails in a List

Hey if I have a list with some cells populated with emails and some empty. how can I automate it so it only finds emails that are missing?