| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing duplicate data from a single list
I have a table of data with 12 columns, one of which is a sequence # column.
I would like to sort the table by that column and eliminate any rows that have duplicate sequence #'s. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
removing duplicate data from a single list
Assuming you have Sequence# in Col A starting in first row, then in the first
unused column's first cell enter the following; =COUNTIF(A1:$A$30,A1) and copy down... You can then filter on values 1 for this column and delete those rows... "Brad" wrote: I have a table of data with 12 columns, one of which is a sequence # column. I would like to sort the table by that column and eliminate any rows that have duplicate sequence #'s. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing non duplicate data | Excel Worksheet Functions | |||
| Delete duplicate data in a single cell | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
