Comparing Cells

[brightyoyo]

Hi I would like to compare data in A1:B1 with the data in D1:E1 and ouput the difference in G1:H1. Here is a sample

C1	C0603C101J5GACT	      [code]C1	C0603C101J5GACT

C10	C2012X7R1E105K

C10 C2012X7R1E105K[/code]

C100 C0603C104K3RAC


C100 C0603C104K3RAC

C101 C0603C102K5RACT C101 GRM188R71H102KA01D

C102 C0603C104K3RAC C102 C0603C104K3RAC

C104 KTJ101B106M55BF C104 CKG57NX7R2A106M

C105 C0603C104K3RAC C105 C0603C104K3RAC

C106 GRM188R71E474KA C106 GRM088R71E474KA

C5 0603C222K5RACT C5 C0603C222K5RACT

C50 KTJ101B106M55BF C50 CKG57NX7R2A106M

C51 GRM32ER71H475KA C51 GRM32ER71H475KA88L

C52 CAPN/U-0603 C52 N/U

C53 CAPN/U-0603 C53 N/U

R12 RMC1/16 1 1% R119 RMC1/10 20 5%

R120 RMC1/10 20 5% R12 RMC1/16 1 1%

R121 RMC1/16 750K 1% R120 RMC1/10 20 5%

R122 RMC1/8 47 5% R121 RMC1/16 750K 1%

R123 RMC1/16 750K 1% R122 RMC1/8 47 5%

R124 RMC1/10 10 1% R123 RMC1/16 750K 1%

R125 RMC1/10 10 1% R124 RMC 1/10 10 1%

R126 RMC1/16 61R9K1% R125 RMC 1/10 10 1%


Thanks

 

[SirJB7]

Hi, brightyoyo!

If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.

http://chandoo.org/wp/2008/11/06/unique-duplicate-missing-items-excel-help/

Regards!

 

[brightyoyo]

That is comparing them vertically< I want to campare horizontally just across row 1.

My data above did not format well, so I will include a sample file


https://www.dropbox.com/s/679s32yp62d58lh/Sample.xlsx

 

[SirJB7]

Hi, brightyoyo!

Give a look at this file:

https://dl.dropboxusercontent.com/u/60558749/Comparing%20Cells%20-%20Sample%20%28for%20brightyoyo%20at%20chandoo.org%29.xlsx

Check for colums O:T instead of G:H.

Regards!

 

[brightyoyo]

I must admit it is a little difficult to follow, so how about a simple true or false depending on whether the data is different.

 

[SirJB7]

Hi, brightyoyo!

Then try applying conditional formatting, this site is plenty of examples about it.

Regards!

 

[SirJB7]

Hi, brightyoyo!


It looks difficult but it's like this:

a) A:B & C:D your 2 double column lists

b) E:F & G:H position of each code in the other list and the related value

c) I: this column is unintentionally left blank

d) J:K & L:M have only the codes with different related value and counts it from 1st row

c) I: this column is intentionally left blank

e) O:Q & R:T have a short ordered list of J:Q & L:M with both values


Hope it helps.


Regards!

 

[NARAYANK991]

Hi ,


In case your problem is not resolved , I have a couple of questions :


1. Can you post a sample result of the difference in G1:H1 ; for example , let us consider the following data from your file :

[pre]

CR33	1SS400TE61		CR33	MA2S11100L
CR37	1SS400TE61		CR38	N/U
CS3	PA1005-100NL		CS3	PA1005-100NL
E8	KFB3-632-6ET		E8

[/pre]
What would be the contents of G1:H1 in each of the above cases ?


2. In the above data , the second row has CR37 in column A ; in your file this data appears in row 72 ; in row 71 , cell A71 has CR37 ; is this CR37 in A72 a typo , or is that the way your data is ?


3. Rows 286 through 291 in your file don't have any data in columns A and B , while data is present in columns D and E ; what will be the output in all of these cases ? This is similar to the last row of sample data I have posted above , where data is present in columns A , B and D , but not in E.


Narayan

 

[brightyoyo]

Hi NARAYANK991 I think conditional format would be the easiest way to go on this comparison after searching aroung the site. Sorry, to waste your time.


Thanks