Ignore blanks in data validation

[@antnfs]

You might have just helped get me a promotion, good job

[@excelenthusiasts]

Thank you. All the best.

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@excelenthusiasts]

You are welcome.

[@abdulraouf727]

simplify solution, Thanks.

[@alibehnam78]

Hi.. Thanks for this. Is there a way for the validation source to update automatically without having to manually click refresh?

[@excelenthusiasts]

No, I don't think so.

[@sahil051989]

Thanks for the video.!! Can you tell me how to get to the power query window..!! I dont see an option there on my excel sheet.!!
Thanks in advance..!!

[@excelenthusiasts]

+Sahil Kapoor Hi. Power Query is an add-in for Excel 2010 and 2013. For Excel 2016, it is built into the application. In Excel 2010/2013, go to Power Query in the ribbon and then to From Table. In Excel 2016, go to Data > From Table.

[@rajeshdebnath8673]

Not visible clearly. Zoom needed

[@excelenthusiasts]

Thank you for the feedback. Will keep that in mind for future recordings.

[@SekadarPendapat]

In this case, googlesheet is better