Compare column B to A, delete occurences found in B, list occurrences on column C

I

IT_Novice

New Member
Joined
May 4, 2009
Messages
2
Hi everyone,

I have a master list of words on column A . I would like to compare words on column B against list A. If occurrences are found on B, I would like to delete them but also list them on column C for verification.

Thanks in advance for all your help. I've received so much help here just by reading through the forums, but I've not been able to find a solution for this one. Hope I've explained this clearly enough.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
IT_Novice said:
Hi everyone,

I have a master list of words on column A . I would like to compare words on column B against list A. If occurrences are found on B, I would like to delete them but also list them on column C for verification.

Thanks in advance for all your help. I've received so much help here just by reading through the forums, but I've not been able to find a solution for this one. Hope I've explained this clearly enough.
Click to expand...


Found a solution here; http://www.mrexcel.com/forum/showthread.php?t=384758&highlight=sheet+larger+master

I'm good on this. Thanks.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Conditional Formatting/Moving Rows Based on Matching and Opposite Data
Replies
1
Views
204
Madam_Xavier
M
H
  • Question Question
VBA to Shift Table Layout from right to left in Excel
Replies
2
Views
63
Peter_SSs
Peter_SSs
ChrisMac1
  • Question Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
369
ChrisMac1
ChrisMac1
E
  • Solved
Looking for a spilled formula returning the value in a table matching 3 conditions
Replies
5
Views
137
ED38
E
B
  • Solved
Looking to expand tool to track vacation pro-rations
Replies
1
Views
264
bh24524
B

Forum statistics

Threads
1,223,270
Messages
6,171,102
Members
452,379
Latest member
IainTru

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