| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count and display unique values | Excel Worksheet Functions | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| Count Unique Values | Excel Worksheet Functions | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Linear Mode
