Compare Lists and Add Missing Items

H

helpexcel

Well-known Member
Joined
Oct 21, 2009
Messages
656
Hi,

Is there a way I can compare the items in Column B to those in Column A. Then any item in Column A that's not in Column B would be added to the next available row in Column B.

Thanks!
 
Sort by date Sort by votes
Just add this line as shown
Rich (BB code): 
With CreateObject("scripting.dictionary")
     .CompareMode=1
 
Upvote 0

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
You must log in or register to reply here.

Similar threads

S
  • Solved
Worksheet Change Event
Replies
3
Views
71
sspatriots
S
D
  • Solved
Drop down list to display only grouped items
2
Replies
11
Views
225
Peter_SSs
Peter_SSs
J
  • Question
Any way to add multiple value fields to a pivot table quicly?
Replies
1
Views
292
arthurbr
arthurbr
A
  • Solved
Formula for subtracting from a total, if a specific item is selected from a dropdown
2
Replies
13
Views
139
mumps
mumps
I
  • Question
Vlookup a column with duplicate value, return the number from the last row
Replies
3
Views
91
etaf
etaf

Forum statistics

Threads
1,215,069
Messages
6,122,954
Members
449,096
Latest member
Anshu121

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