How to identify different records from 2 columns.

[ThrottleWorks]

Hi,


I have a data consisting 2 columns, column A & columns B.

Both the columns have same numbers of alpha numeric records.


The values will be like this,


Range A1 = abc12 Range B2 = aa12

Range A2 = abc12 Range B2 = aa12

Range A3 = qw12 Range B3 = aa13


I want to check whether there are multiple values in column A for the same value in column B.


I do not want to assign multiple value.


For example wrong data will be something like this.


Range A1 = abc12 Range B2 = aa12

Range A2 = edc12 Range B2 = aa12


I want to highlight this “edc12” value by using VBA.

Can anyone help me in this please.

 

[Debraj]

Hi Sachin..


Can you please allow me to overlook the the last word in second last line.


* Select Column A & B.

* Go to Conditional Formatting.. > Use formula to Decide..

* use formula as

=$A1<>INDEX($A:$A,MATCH($B1,$B:$B,0))

and set your desired Format..


It will highlight all not matching value form its 1st occurrence in the same column.. So if 1st occurrence of aa12 is "edc12" then it will highlight "abc12"..


Regards,

Deb

 

[ThrottleWorks]

You are star, thanks a lot for the help.


Have a nice day Sir.