find duplicates in 2 columns

E

excel/newbie

New Member
Joined
May 20, 2011
Messages
1
How do I compare two columns in Excel 2003 and have it highlight the duplicates so I can delete those rows?

I receive a report with audited loan numbers everyday and I need to take those audited loan numbers out of my master report so I don't do a duplicate audit on them. I thought it would be easiest to add a column to my master report and paste the audited loan numbers in it. Then have Excel compare the two columns and highlight the dulpicates so I can just delete those rows and continue with my audit. I'm new to formulas in excel..
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

H
  • Question Question
Using XLOOKUP in VBA to lookup value underneath specific header name (columns can change depending on worksheet)
Replies
0
Views
164
Hailee994
H
dezibluenose
  • Solved
Trying to combine If statements
Replies
3
Views
409
etaf
etaf
P
  • Question Question
Need suggestions on what to use for a real time tracker which auto refreshes the data every hour.
Replies
1
Views
324
Peter_SSs
Peter_SSs
A
  • Solved
count how many times text string appears in column
Replies
2
Views
222
ajm
A
S
  • Question Question
Excel VBA - Sort & Get Totals - Logic
Replies
4
Views
419
STARL0RD
S

Forum statistics

Threads
1,224,618
Messages
6,179,917
Members
452,949
Latest member
beartooth91

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