brightyoyo
New Member
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
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
Code:
C1 C0603C101J5GACT [code]C1 C0603C101J5GACT
C10 C2012X7R1E105K
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