One way to do what you are asking is to create a pivot table on the
data. If you drag the desired column into the left column of the pivot
table format, it will only pick up unique values. let me know if you
need more details. The wizard is pretty good for pivot tables. Later
- Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=515179