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.