Snasui Excel Forum

Hi Dear

Hope everyone here safe

I need your help to do data validation from cells ignoring blanks.
I can use a helper and named range to do.
Is it having a formula or UDF to do this without helper just use only named range?

Thanks

Here is an attached

The validation can't accept array either by direct formula or formula in name manager. If you need VBA please try by yourself first.

Noted.Thank you so much