Microsoft Office Forums Comparing two sheets and deleting double entries?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2018, 03:28 PM
MAD King MAD King is offline Comparing two sheets and deleting double entries? Windows 7 64bit Comparing two sheets and deleting double entries? Office 2016
Novice
Comparing two sheets and deleting double entries?
 
Join Date: May 2018
Posts: 1
MAD King is on a distinguished road
Default Comparing two sheets and deleting double entries?

Hello,

I would need help with following and hope someone has the answer.



I have a workbook with two sheets.
The first sheet has 5,000 rows with values in.
The second has the same values in, but only 1,000 of that which the first sheet has.
I do not want to sit there like Cinderella and go through each line to delete them in sheet one.
Since Microsoft is so intelligent, I thought that there must be a way to have this done automatically.

Can someone please help me with that?

Thank you
Reply With Quote
  #2  
Old 05-12-2018, 03:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Comparing two sheets and deleting double entries? Windows 7 64bit Comparing two sheets and deleting double entries? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome



One of the possibilities is explained here
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting old tasks, emails and calendar entries thelonius Outlook 1 07-22-2017 09:03 PM
Comparing excel sheets ALAPHRIDUS Excel 5 06-07-2017 01:31 PM
Comparing two sheets and deleting double entries? new to VBA help comparing two sheets mlttkw Excel Programming 1 04-21-2016 08:32 AM
Mouse double click problem in part protected sheets rene01 Excel 0 08-25-2010 07:33 AM
Print Multiple Sheets Double-Sided flambe99 Excel 1 03-12-2010 01:15 PM


All times are GMT -7. The time now is 07:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft