Ignoring Blank value in a drop down list

S

shail

Hi Leo,

Thanks for the post. Yes, I have been waiting for the new formula by
you everyday. Also trying to get how the formula posted by you is
working (and literally, I am scratching my hairs.. hahaha)

Thanks again.

Shail
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Remove blank cells from data validation drop down box 3
customize drop-down box 1
drop down list 3
Formatted cell column in drop down list 1
Excel Excel: How do I put a formula in a drop down list 11
Drop Down with dynamic named range offsheet source list 14
Drop Down Starting Position 2

Top