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 |
