Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 6th 04, 10:07 PM posted to microsoft.public.excel.programming
ali ali is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2004
Posts: 1
Default 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   Report Post  
Old March 6th 04, 10:27 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 3,885
Default 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   Report Post  
Old March 6th 04, 11:18 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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   Report Post  
Old March 6th 04, 11:24 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 3,885
Default 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   Report Post  
Old March 6th 04, 11:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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   Report Post  
Old March 6th 04, 11:53 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 3,885
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate unique values among duplicates Toby Excel Worksheet Functions 6 April 15th 09 05:55 PM
Duplicates and unique values sragor Excel Worksheet Functions 1 February 3rd 09 09:22 AM
Identifying unique values among duplicates bob Excel Worksheet Functions 4 November 10th 08 10:43 PM
Counting Unique Values with Duplicates DOUG ECKERT[_2_] Excel Discussion (Misc queries) 0 May 8th 08 03:00 PM
check for duplicates, then sum unique values Weissme Excel Discussion (Misc queries) 0 August 9th 06 04:35 PM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017