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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,215,603
Messages
6,125,786
Members
449,259
Latest member
rehanahmadawan

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