Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing non duplicate data
I have a worksheet that has one column of data, most of it is repeated. What
I would like is to have a formula that will take the data in column one and take out the non repeated data and put that in column two. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing non duplicate data
No formula will do that. Use Data - Filter - Advanced Filter and specify
Unique records. That will display only the unique records in Column A. Copy that and paste it to Column B. HTH Otto "freeman" wrote in message ... I have a worksheet that has one column of data, most of it is repeated. What I would like is to have a formula that will take the data in column one and take out the non repeated data and put that in column two. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing duplicate rows | Excel Discussion (Misc queries) | |||
removing duplicate rows | Excel Discussion (Misc queries) | |||
Is there a simple way of removing duplicate data in Excel? | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Removing Duplicate Data | Excel Worksheet Functions |