I would do something like the attached. It could be made more sophisticated, but this is a quick and dirty solution making use of the recently available UNIQUE function to assure no duplicates.
Hit F9 to generate a new list. The highlighted cells are your unique nine.
