Non unique records only

[mit05]

Hi,

I would like to get from a range the non unique records. Something like
advanced filter do for unique record only.

How can I do that?

Thanks

 

[Jim Jackson]

Are you thinking of records that fit within certain specs?

Selection.AutoFilter Field:=1, Criteria1:="> A", Criteria2:="< G"

 

[mit05]

Hi,

If I have 2 columns of data in range A1:B10

FIELD1|FIELD2
A|12
A|10
B|50
B|50
C|22
C|21
C|21
A|10
C|21

The macro will allow me to select the range A1:B10 and , for example, the
cell C1.
The macro will produce this output in range C14

FIELD1|FIELD2
A|10
B|50
C|21

That are the non unique records of range A1:B10 (with heading)

Regards