| 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 |
| 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) | |||
Threaded Mode
