compare and match

**prasjohn** · 08-27-2015, 02:10 AM

Hi all, I am new to VBA, so need some help... I have two columns, list A and list B with some names. I want a formula which can compare between A and B and give result in each row(in C) as 3 categories: (1) present in A, but not in B (2)present in B, but not in A (3)present in both. Also note that last filled row is not fixed, so could by any, and result should appear in column C, if data is present in column A and B. Any help will be appreciated. Regards Prasjohn

List A List B Expected Result
apple orange present in both
orange banana in List B only
pine Guava in List B only
Grapes pine in List A only
strawberry dates in List B only

**Kaper** · 08-27-2015, 06:56 AM

I do not think you described problem well.
Let's focus on column B and orange and pine entries.
Why these are listed as once present in both (its for orange, because apple is only in A) and once List A only (pine is in both)?
in my opinion right output shall be two-fold itemA present in .(either both or A only). and item B present in .(either both or B only).

**Kaper** · 08-27-2015, 07:03 AM

By the way, you can have this output also from formula. for C1:

Formula:

Please Login or Register  to view this content.

**prasjohn** · 09-03-2015, 02:17 AM

Thanks Kaper.. You are right.. It worked the way I want...Regards..

compare and match

LinkBack

Thread Tools

Rate This Thread

Display

compare and match

Re: compare and match

Re: compare and match

Re: compare and match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Compare and Match

[SOLVED] VBA Compare & Match

VBA: Compare, copy, and match

Compare a range of cells to a specific cell, if match, compare another cell on same row

Compare/Match two columns

Compare/Match two columns

Can't use match to compare two columns

[SOLVED] Compare and Match Functions

Bookmarks

Bookmarks

Posting Permissions