copy only unique values

S

Sweetetc

I have 2 columns of data. How can I create a 3rd column of only unique data?

ex>
Column A Column B
197199201/19000000/08/21/2005/190 197199201/19000000/12/31/2002/376
197199201/19000000/08/21/2005/190 197199201/19000000/12/31/2002/376
197199607/19000000/08/21/2005/190 197199607/19000000/12/31/2002/376
197199607/19000000/08/21/2005/190 197199607/19000000/12/31/2002/376

Column C should return
197199201/19000000/08/21/2005/190
197199201/19000000/12/31/2002/376
197199607/19000000/08/21/2005/190
197199607/19000000/12/31/2002/376
 
S

Sweetetc

Peo

Thanks for your quick response. My concern about cut and past is the
columns are very lenghty and I am trying to avoid unecessary manipulation.
Is there know formula that would allow this to be done from the 2 columns?
--
Thanks
ETC


Peo Sjoblom said:
Copy column B into column A (if there is room), then apply
data>filter>advanced filter, select copy to another location and unique
records only


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
Click to expand...
 
Top