remove duplicates 2007 doesn't work

M

mljohn

Board Regular
Joined
Aug 26, 2004
Messages
196
Office Version
  1. 365
Platform
  1. Windows
I have one column of part numbers that contains duplicates.

I conditionally format the column to show duplicates in red.

Then I click on the "Remove Duplicates" in the DATA tab and it says that the duplicates have been removed but I can see that they have not.

Why?

How do I remove the duplicates?

Matt
 
Sort by date Sort by votes
mziaei110 said:
It's a bug when you have a mix of texts and numbers.
Sort your data first, then remove duplicates
Click to expand...
I believe that it is fixed in the latest version(s). Certainly the examples of failure that I had with older versions (here is one that I used to refer people to) now do not fail with my Excel 365.
 
Upvote 0

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

D
  • Question Question
Data Validation List without duplicates
2 3
Replies
23
Views
469
kvsrinivasamurthy
K
S
  • Question Question
SUMIFS while ignoring duplicate rows based on values from a column
Replies
4
Views
389
slam
S
S
  • Question Question
Compressing large amount of rows but adding totals?
Replies
6
Views
157
jkpieterse
jkpieterse
G
  • Question Question
Remove duplicate words
2
Replies
13
Views
496
giannip
G
Y
  • Solved
Macro errors out when run automatically, but no problem when step-by-step
Replies
3
Views
347
Alex Blakenburg
A

Forum statistics

Threads
1,225,156
Messages
6,183,230
Members
453,152
Latest member
ChrisMd

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