help find not 'exact'

[joeloveszoe]

hi
i have 3 columns in a spreadsheet

i want to extract the blanks from A (or B) that dont match the exact sku in B (or A)
is there a quick find/sort way to do this?

thanks in advance for your help!!!
joe =)

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica; min-height: 13.0px}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR3140
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4200
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR4202
[/TD]
[TD="class: td1"]QUAR4202
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4210
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4290
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4292
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4430
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4440
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4450
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4460
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4492
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4497
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4500
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4510
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4520
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4610
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR4611
[/TD]
[TD="class: td1"]QUAR4611
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4620
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4630
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR4650
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR5101
[/TD]
[TD="class: td1"]QUAR5101
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR5106
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR5110
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR5121
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR7050
[/TD]
[TD="class: td1"]QUAR7050
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR7501
[/TD]
[TD="class: td1"]QUAR7501
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR7525
[/TD]
[TD="class: td1"]QUAR7525
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAR7545
[/TD]
[TD="class: td1"]QUAR7545
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]

[/TD]
[TD="class: td1"]QUAR9975
[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]QUAS3610
[/TD]
[TD="class: td1"]QUAS3610
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica; min-height: 13.0px}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]PFXR217MHD
[/TD]
[TD="class: td1"]PFXR217MHD
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFXR219AHD
[/TD]
[TD="class: td1"]PFXR219AHD
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFXR75213
[/TD]
[TD="class: td1"]PFXR75213
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFXR75215
[/TD]
[TD="class: td1"]

[/TD]
[TD="class: td1"]FALSE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFXR752
[/TD]
[TD="class: td1"]PFXR752
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFXR75313
[/TD]
[TD="class: td1"]PFXR75313
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFXRCY415215SGR
[/TD]
[TD="class: td1"]PFXRCY415215SGR
[/TD]
[TD="class: td1"]TRUE
[/TD]
[/TR]
</tbody>[/TABLE]

 

[mumps]

Place this formula in C1 and copy it down the column: =IF(A1=B1,"True","False")