VBA array difference

[nikhileshp]

I have a VBA code to compare two columns (A & B) having comma separated values. Two custom functions are defined in VB code and I get the result in next two columns (C & D). Col C gives me values that exist in A but not in B. Col. D gives me values that exist in B but not in A.

I want a custom function which should give me values common in both A and B columns.

Suppose
I want
Col A Col B Col C Col D Col E
a,b,c,d b,c,d,f a f b,c,d

Details attached in excel file
csv-split-function.xlsm

[jindon]

Try

=GetAllDiff($A1,$B1,COLUMN(A1))
Then copy to the right

Please Login or Register  to view this content.

[patel45]

Hi jindon
very good code, but you missed to use a(3), I suggest some changes

Please Login or Register  to view this content.

[jindon]

patel45

1st column = appears only in A1
2nd column = appears only in B1
3rth column = appears in both

That's how I read the problem.

[patel45]

Yes, you are right, I copied only 1 time to the right, I read bad I apologize

[nikhileshp]

Dear Jindon,
That was a Great Help for me.

Nikhilesh

[Cutter]

@ nikhileshp

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[snb]

Why so complicated ?

Please Login or Register  to view this content.

[patel45]

very good snb, but to complete the job

Please Login or Register  to view this content.

b