Find missing data in columns ignoring blanks, separated by semicolon

Guys,

I am trying to cut down on several steps. I have a sheet that i will paste in two sets of values. I am trying to compare column A to column B and find everything column A has that B doesn't. Finally, i need to concatenate them into one cell, separated by a semicolon and ignoring any blanks.

A B C
1 2 1;4;5;6
2 3
3
4
5
6

I would prefer VBA over forumula.

thanks

I have attached my sheet. I will paste user1 and user2's values in the MAIN tab. Drag the formulas as necessary in column C. Then i will filter out all the blanks in C column, paste them into the RESULTS tab and concatenate them together. Find/Replace all the "&" signs with &";"& to add a semicolon between each value.

I am looking for something quicker.

Hi..

Try this.. no formulas needed.. just paste your value sin column A and B..

Please Login or Register  to view this content.

Try the attached.

Perfect Apo! Thanks

Ok Apo, I thought I was going to be able to reverse it, but too many things I don't understand. After i check for missing values in column B, i want to see if column B has anything that A doesn't. Any way to switch it in reverse?

Where do you want the result shown for when it is 'reversed'..?

Do you want it to overwrite whatever is in C2 or show the result separately somewhere else?

Na......c5 is good

Try this..

Please Login or Register  to view this content.

Worked perfectly! Thanks again

You're welcome..