Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove all records of duplicated fields?
I am using excel 2002. I have a row of data, with some duplicated records. I
want to be able to delete ALL duplicates. e.g. bob bob scott john would delete all record of bob leaving just the following: scott john How can I achieve this? Any help will be greatly appreciated. Many thanks -- nozzaworld |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove all records of duplicated fields?
The Common and known options is to use Advanced Filter to filter "Uniques
Only". Micky "nozzaworld" wrote: I am using excel 2002. I have a row of data, with some duplicated records. I want to be able to delete ALL duplicates. e.g. bob bob scott john would delete all record of bob leaving just the following: scott john How can I achieve this? Any help will be greatly appreciated. Many thanks -- nozzaworld |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove all records of duplicated fields?
Sorry... I didn't noticed you entire rquest.
1) Start your records in Cell A2. 2) In cell A1 type some header. 3) After [to the right of the last field in the first record] type: =COUNTIF(A$2:A$5,A2) and copy down until the last record. 4) Use "Automatic Filter" - in the formula column - to filter out only the 1. 5) You will see' now only the requested records. 6) Copy/paste them into a different range and/or sheet. Micky "מיכאל (מיקי) אבידן" wrote: The Common and known options is to use Advanced Filter to filter "Uniques Only". Micky "nozzaworld" wrote: I am using excel 2002. I have a row of data, with some duplicated records. I want to be able to delete ALL duplicates. e.g. bob bob scott john would delete all record of bob leaving just the following: scott john How can I achieve this? Any help will be greatly appreciated. Many thanks -- nozzaworld |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove all records of duplicated fields?
Micky,
it seems a double-post, I provided the very same solution to him here, and am about to tackle the second half of the problem: http://www.microsoft.com/office/comm...564&sloc=en-us "מיכאל (מיקי) אבידן" wrote: Sorry... I didn't noticed you entire rquest. 1) Start your records in Cell A2. 2) In cell A1 type some header. 3) After [to the right of the last field in the first record] type: =COUNTIF(A$2:A$5,A2) and copy down until the last record. 4) Use "Automatic Filter" - in the formula column - to filter out only the 1. 5) You will see' now only the requested records. 6) Copy/paste them into a different range and/or sheet. Micky "מיכאל (מיקי) אבידן" wrote: The Common and known options is to use Advanced Filter to filter "Uniques Only". Micky "nozzaworld" wrote: I am using excel 2002. I have a row of data, with some duplicated records. I want to be able to delete ALL duplicates. e.g. bob bob scott john would delete all record of bob leaving just the following: scott john How can I achieve this? Any help will be greatly appreciated. Many thanks -- nozzaworld |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove duplicated data repeated.... | Excel Worksheet Functions | |||
remove records when fields match in 2 worksheets?? | Excel Worksheet Functions | |||
How do you use filter to view duplicated records in Excel? | Excel Discussion (Misc queries) | |||
How to delete duplicated records. Each record has four lines | Excel Discussion (Misc queries) | |||
Remove ALL duplicated records, leaving behind NONE | Excel Discussion (Misc queries) |