What is an Excel macro that will check every cell in column A for whether they have unique numbers or are blank?
Does this do the job for you?