|
copy only unique values
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 -- Thanks ETC |
copy only unique values
Copy column B into column A (if there is room), then apply
datafilteradvanced filter, select copy to another location and unique records only -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Sweetetc" wrote in message ... 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 -- Thanks ETC |
copy only unique values
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" wrote: Copy column B into column A (if there is room), then apply datafilteradvanced filter, select copy to another location and unique records only -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Sweetetc" wrote in message ... 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 -- Thanks ETC |
| All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com