Removing duplicates

L

Legacy 15162

Guest
How can I search an excel document and remove duplicates?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
You can always do a FIND and REPLACE. You would have to do it manually. The alternative would be a macro. I can customize a macro for you if you offer the criteria. What is the range of cells? How many sheets?
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Conditional removal of duplicates
2
Replies
11
Views
517
Joe4
Joe4
C
  • Solved
Help to remove specific named duplicate word from a cell
2
Replies
11
Views
447
Cruiser69
C
W
  • Question
Filtering Duplicates between 2 columns and removing rows
Replies
1
Views
241
kevin9999
K
A
  • Solved
Remove Duplicates - first instance
Replies
8
Views
718
JoeMo
J
C
  • Solved
Removing Duplicates
Replies
3
Views
625
kevin9999
K

Forum statistics

Threads
1,214,638
Messages
6,120,674
Members
448,977
Latest member
moonlight6

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