I have A1:A100 which is all formulas resultiong in either (a) blank in the form of "" or (b) a date

I want B1:B100 to be populated w/ just the unique values, please