How do you ignore blank cells in data validation ranges? I know there's a
check box that says "Ignore Blanks" but that doesn't seem to work for me. If
I have a list of potentially 5 cells that could contain values, but only 3 of
them do, is there a way to ignore the 2 blank cells, but when there is a
value there, for it to register?

Thanks.