Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying duplicates/unique values
Hi,
Would anyone be able to help me with the following please. I want to select a range of rows use a macro to identify which of thos entries are duplicates - ie the entire row matches another row in th selection? In an ideal situation the duplicates will be moved to a new sheet called duplicates - with the unique rows being moved to a new shee called uniques. The original data will remain in the original sheet. Many many thanks for any help you can offe -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying duplicates/unique values
Hi
without macros - select your range - goto 'Data - Filter - Advanced Filter' - check 'Unique values' and choose your other sheet as target location - finish the wizard -- Regards Frank Kabel Frankfurt, Germany Hi, Would anyone be able to help me with the following please. I want to select a range of rows use a macro to identify which of those entries are duplicates - ie the entire row matches another row in the selection? In an ideal situation the duplicates will be moved to a new sheet - called duplicates - with the unique rows being moved to a new sheet called uniques. The original data will remain in the original sheet. Many many thanks for any help you can offer --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying duplicates/unique values
Although the right thought, that will evoke an error message (you can only
copy data to the active sheet). To get this to work going to another sheet, you have to start from the destination. You should select a cell on the destination sheet, then do Data=Filter=Advance Filter. You may get a message that it can't find your data, but just click OK and continue. You can then select in the resulting dialog and specify copy to another location, then click in the List Range box and navigate to and highlight your data range, (leave criteria blank), and click the unique values checkbox, then click OK. -- Regards, Tom Ogilvy "Frank Kabel" wrote in message ... Hi without macros - select your range - goto 'Data - Filter - Advanced Filter' - check 'Unique values' and choose your other sheet as target location - finish the wizard -- Regards Frank Kabel Frankfurt, Germany Hi, Would anyone be able to help me with the following please. I want to select a range of rows use a macro to identify which of those entries are duplicates - ie the entire row matches another row in the selection? In an ideal situation the duplicates will be moved to a new sheet - called duplicates - with the unique rows being moved to a new sheet called uniques. The original data will remain in the original sheet. Many many thanks for any help you can offer --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying duplicates/unique values
Hi Tom
thanks for the addition - though this seems to be a strange Excel behaviour Also in my Excel version (Excel 2003,German) the other way (starting with the source sheet) works! -- Regards Frank Kabel Frankfurt, Germany Tom Ogilvy wrote: Although the right thought, that will evoke an error message (you can only copy data to the active sheet). To get this to work going to another sheet, you have to start from the destination. You should select a cell on the destination sheet, then do Data=Filter=Advance Filter. You may get a message that it can't find your data, but just click OK and continue. You can then select in the resulting dialog and specify copy to another location, then click in the List Range box and navigate to and highlight your data range, (leave criteria blank), and click the unique values checkbox, then click OK. "Frank Kabel" wrote in message ... Hi without macros - select your range - goto 'Data - Filter - Advanced Filter' - check 'Unique values' and choose your other sheet as target location - finish the wizard -- Regards Frank Kabel Frankfurt, Germany Hi, Would anyone be able to help me with the following please. I want to select a range of rows use a macro to identify which of those entries are duplicates - ie the entire row matches another row in the selection? In an ideal situation the duplicates will be moved to a new sheet - called duplicates - with the unique rows being moved to a new sheet called uniques. The original data will remain in the original sheet. Many many thanks for any help you can offer --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying duplicates/unique values
They may have changed the behavior (which is great), but I assure you it
doesn't work in xl97 and xl2000. -- Regards, Tom Ogilvy "Frank Kabel" wrote in message ... Hi Tom thanks for the addition - though this seems to be a strange Excel behaviour Also in my Excel version (Excel 2003,German) the other way (starting with the source sheet) works! -- Regards Frank Kabel Frankfurt, Germany Tom Ogilvy wrote: Although the right thought, that will evoke an error message (you can only copy data to the active sheet). To get this to work going to another sheet, you have to start from the destination. You should select a cell on the destination sheet, then do Data=Filter=Advance Filter. You may get a message that it can't find your data, but just click OK and continue. You can then select in the resulting dialog and specify copy to another location, then click in the List Range box and navigate to and highlight your data range, (leave criteria blank), and click the unique values checkbox, then click OK. "Frank Kabel" wrote in message ... Hi without macros - select your range - goto 'Data - Filter - Advanced Filter' - check 'Unique values' and choose your other sheet as target location - finish the wizard -- Regards Frank Kabel Frankfurt, Germany Hi, Would anyone be able to help me with the following please. I want to select a range of rows use a macro to identify which of those entries are duplicates - ie the entire row matches another row in the selection? In an ideal situation the duplicates will be moved to a new sheet - called duplicates - with the unique rows being moved to a new sheet called uniques. The original data will remain in the original sheet. Many many thanks for any help you can offer --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying duplicates/unique values
Tom Ogilvy wrote:
They may have changed the behavior (which is great), but I assure you it doesn't work in xl97 and xl2000. No doubt in that :-) So maybe MS does some bugfixing/feature enhancement at least |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate unique values among duplicates | Excel Worksheet Functions | |||
Duplicates and unique values | Excel Worksheet Functions | |||
Identifying unique values among duplicates | Excel Worksheet Functions | |||
Counting Unique Values with Duplicates | Excel Discussion (Misc queries) | |||
check for duplicates, then sum unique values | Excel Discussion (Misc queries) |