Excel added “goat” to the drop-down list (Figure C). You didn’t have to do a thing, other than enter the new list item. That’s the power of Excel’s Table object.

Excel will display the cell reference for the entire data set or Table object as the List Range. If you retain this selection, Excel will return a unique data set based on all the columns.