I'll choose like $A$1:$A$100 as the list and the "Ignore blank cells" is checked, but when I create the list, all of the blanks are still included.

The list of $A$1:$A$100 contain if statements of

=IF(Main!$A1="","",Main!$A1)

Does that make a difference?
Can anybody help?