i have looked at the Contexture site, namely this very helpful article
http://www.contextures.com/xlDataVal13.html

can the OFFSET formula be modified to extract unique items from a list, should the list contain more than one instance of a name? or do i have to create a separate list of unique items to be used by the dependent dropdown?