Hi Chris,

You can create a UDF (IUser-Defined Function) to generate this list for
you. Check this post :
http://www.chalouhis.com/XLBLOG/arch.../unique-cells/

HTH

Fadi