| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Duplicates
I have a list of numbers in column A as follows:
133150 133150 133150 133154 133154 133154 133155 133156 133156 133156 198355 198355 198355 198355 I would like to delete the duplicate values in this list. I can utilize column B if necessary. Can anybody help? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting Duplicates
See reply to your other post.
Gord On Wed, 3 Feb 2010 14:20:01 -0800, Angie M. wrote: I have a list of numbers in column A as follows: 133150 133150 133150 133154 133154 133154 133155 133156 133156 133156 198355 198355 198355 198355 I would like to delete the duplicate values in this list. I can utilize column B if necessary. Can anybody help? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting Duplicates
A simple IF statement should work, as long as your data is sorted numerically.
In column B enter: =IF(A1=A2,"X","") All duplicated numbers will have an "X", then filter for the X's . "Angie M." wrote: I have a list of numbers in column A as follows: 133150 133150 133150 133154 133154 133154 133155 133156 133156 133156 198355 198355 198355 198355 I would like to delete the duplicate values in this list. I can utilize column B if necessary. Can anybody help? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Duplicates | Excel Discussion (Misc queries) | |||
| Deleting Duplicates | Excel Discussion (Misc queries) | |||
| Deleting duplicates | Excel Discussion (Misc queries) | |||
| Deleting Duplicates | Excel Worksheet Functions | |||
| Deleting the first row of two duplicates. | Excel Discussion (Misc queries) | |||
Linear Mode
