• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to omit formula blanks in drop down

Kyle Anderson

New Member
Hello y'all, I'm trying to create a drop down (via data validation) and I'm having trouble getting the list to not include blank cells (with index matches in them). I cannot in any way determine what the full range of cells will be for the drop down because the workbook I am creating is meant to be used by different people who will input different quantities of data. Most of the solutions I have found require knowing how many cells are in the range, so I come humbly to you wise chandoo folk in search of help.
 
Back
Top