ASAP utilities is an add-in that you can install on your computer to use in Excel. it has a feature that you can use to select a range of data (either rows or columns) and delete all duplicate values from the range, keeping the first value. you can download this add-in at
http://www.asap-utilities.com.
i am sure there is a way to do this with VBA, but there are a lot of very useful features in this add-in, and it is well worth the time it takes to download.
HTH
kevin