Excel VB Script

Question

I have two sets of data that contains some of the same information. This data is Names, b-days and other information about people. Each person is contained in one row through multiple columns.

Any ideas of how to make a script through VB to check all information from one person in one set of data with all of the data in the other set? I need to Highlight any names that are not in both sets. e.g. (If another way in excel is available that works too) Cannot download any other software

Set 1

Somebody, Bob 9/2/2012 Male 
Someonelse, Joe 8/16/1950 Male

Set 2

Somebody, Bob 9/2/2012 Male

In this case I would need to highlight Someonelse, Joe in Set 1.

Acual data contains a few thousand people. Efficiency of script not a huge deal, as long as it gets the job done.

I'm sorry in Set 1, the two names should be on seperate rows — Scape
– Scape, Commented May 10, 2012 at 15:16
In this case I would need to highlight Someonelse, Joe in Set 1. If the data Somebody, Bob 9/2/2012 Male is in 1 cell then why not use a countif formula to find the data which is not present in set 2? — Siddharth Rout
– Siddharth Rout, Commented May 10, 2012 at 15:26
Do you have an example? I'm not very familiar with how Excel works. Thank you! — Scape
– Scape, Commented May 10, 2012 at 15:28

Siddharth Rout · Accepted Answer · 2012-05-10 15:34:20Z

1

Do you have an example? I'm not very familiar with how Excel works. Thank you! – Scape 27 secs ago

If your intention is to find the values which are not in SET 2 then you can use the Countif formula in conjunction with an IF formula. See the snapshot.

enter image description here

And if you want to highlight the cell then use conditional formatting using a formula :)

enter image description here

answered May 10, 2012 at 15:34

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Scape Over a year ago

Thank you Siddharth Rout! This helped a lot.

Collectives™ on Stack Overflow

Excel VB Script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related