CODEWITHSUNDEEP
excelduplicates
Patrícia Villela
Patrícia Villela

Reputation: 839

Selecting duplicate records

I need to copy all the duplicates in a certain sheet, but can't remove. I'm in Excel.

Data samples:

Line__ID___________Value

1_____1____________14

2_____1____________134

3_____2____________15

4_____2____________15

5_____3____________17

6_____3____________16

7_____3____________17

I need to do a CRTL+C in those lines with both duplicated, like lines 3 and 4; and lines 5 and 7.

Upvotes: 0

Views: 88

Answers (2)

Lance Roberts
Lance Roberts

Reputation: 22842

Choose the Advanced Filter from the Data->Filter menu, and check the box for Unique Values. Then cut and paste what you want. Then turn it back off.

Upvotes: 0

Jean-François Corbett
Jean-François Corbett

Reputation: 38530

Use the Copy method. 

Range("D4:E5").Copy

There. You've copied that range to the clipboard. Assuming that's what mean by "doing a CRTL+C"...

I wonder what exactly you're planning to do once this is in the clipboard.

Upvotes: 1

Related Questions