I am trying to make a Data Validation list from one of my tables, but I can't seem to get the UNIQUE function to work in the Name Manager. If I create a new Name called "Sports" and use the formula, it works just fine. However, I want the unique values from there. I don't want it to repeat "Baseball" 50 times before I get to "Basketball" in my drop-down list. But whenever I use the formulaor, it returns an error. Both of those work fine when I enter them into a blank cell on a sheet, but the Name Manager keeps saying that they return an error when I try to make a Name out of them. Does anybody have any idea why this is occurring, or how to fix it?