Hi guys, I've been trying to work this out no no avail. I have a drop-down list that references a Table with 4 categories. The first space blank cell is shown as a space, but any spaces thereafter are not shown. Im guessing it's using some sort of UNIQUE searching under the hood. Is there a way to show ALL blank cell gaps as spaces?
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Apples | ||||
2 | Bananas | ||||
3 | Carrots | ||||
4 | |||||
5 | Baking Soda | ||||
6 | Flour | ||||
7 | Sugar | ||||
8 | |||||
9 | Coke | ||||
10 | Pepsi | ||||
11 | Sprite | ||||
12 | |||||
13 | Frozen Pie | ||||
14 | Ice Cream | ||||
15 | Italian Ice | ||||
Sheet1 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
C5 | List | =$A$1:$A$15 |