Remove Duplicates Leaves 1 duplicate pair behind

P

postjo

New Member
Joined
Dec 4, 2009
Messages
37
Hi,
I have a large table of data and I am trying to remove the duplicates in a column. I am using Data>Remove Duplicates

This is working fine except that in every case it leave one duplicate pair behind. It deletes the rows containing the duplicates and then below the empty rows there is one row of data containing a one part of a duplicate.

Does anyone know why this is happening?

It's annoying i have to manually remove one row to get rid of all the dupes.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
I am having the exact same problem. Remove Duplicates sometimes leaves the very last row, as if it is fixed in place.

For example I have 5,202 rows of data including a header row. I remove dupes in column 2, it gets 3,259 leaving 1,941 in Rows 2 to 1942. Then empty rows down to 5,202 where I have the one dupe it did not catch.

I use remove duplicates very frequently, not sure why this started to happen lately ... tried with and without the header, tried with multiple columns, etc. Any known solutions?
 
Upvote 0
chirp said:
write a macro for it!!
Click to expand...

Yeah, that's sort of missing the point I guess. I do not feel the need to write a macro to catch the one remaining dupe. I can resort and then run remove duplicates a second time to get it.

The point would be to understand why the menu item is not working as expected.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Combine pairs of duplicate rows while totalling dollar values for each pair
Replies
1
Views
105
Joe4
Joe4
H
  • Solved
problem with code- removing duplicate rows
Replies
2
Views
143
heathball
H
D
  • Solved
remove duplicate if cell appears twice macro
2
Replies
15
Views
516
daveyc18
D
A
  • Solved
Remove Duplicates - first instance
Replies
8
Views
723
JoeMo
J
T
  • Question
Remove Duplicates with Dynamic Columns Array
Replies
0
Views
298
trough
T

Forum statistics

Threads
1,215,011
Messages
6,122,677
Members
449,092
Latest member
tayo4dgacorbanget

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top