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>

	QUAR3140	FALSE
	QUAR4200	FALSE
QUAR4202	QUAR4202	TRUE
	QUAR4210	FALSE
	QUAR4290	FALSE
	QUAR4292	FALSE
	QUAR4430	FALSE
	QUAR4440	FALSE
	QUAR4450	FALSE
	QUAR4460	FALSE
	QUAR4492	FALSE
	QUAR4497	FALSE
	QUAR4500	FALSE
	QUAR4510	FALSE
	QUAR4520	FALSE
	QUAR4610	FALSE
QUAR4611	QUAR4611	TRUE
	QUAR4620	FALSE
	QUAR4630	FALSE
	QUAR4650	FALSE
QUAR5101	QUAR5101	TRUE
	QUAR5106	FALSE
	QUAR5110	FALSE
	QUAR5121	FALSE
QUAR7050	QUAR7050	TRUE
QUAR7501	QUAR7501	TRUE
QUAR7525	QUAR7525	TRUE
QUAR7545	QUAR7545	TRUE
	QUAR9975	FALSE
QUAS3610	QUAS3610	TRUE

<tbody>
</tbody>

<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>

PFXR217MHD	PFXR217MHD	TRUE
PFXR219AHD	PFXR219AHD	TRUE
PFXR75213	PFXR75213	TRUE
PFXR75215		FALSE
PFXR752	PFXR752	TRUE
PFXR75313	PFXR75313	TRUE
PFXRCY415215SGR	PFXRCY415215SGR	TRUE

<tbody>
</tbody>

 

[mumps]

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