Avatar of Flora Edwards
Flora Edwards
Flag for Sweden

asked on 

how to ignore blank cells from the data validation list?

I have the attached workbook.

i have used the formula in the dropdown list of data validation list.

as you can see if my data has blank cells they still appear in the dropdown. how can this be modified so that it does not list the blank cells in the dropdown?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon