Search range for text not in another range
 

I want to find all cells in column A that do not have an identical matching
cell in column C. Ideally I'd then like to list these in column D. Columns A
and C only contain text.

Search range for text not in another range
 

Assuming your first data line starts in cell A1, in column D1 use the formula
=exact(A1,C1). This will return a true or false value.

"simon howard" wrote:

I want to find all cells in column A that do not have an identical matching
cell in column C. Ideally I'd then like to list these in column D. Columns A
and C only contain text.

Search range for text not in another range
 

Thanks Reneets for your quick reply - I should have made it clear that the
matching cell in column C could be anywhere in that column (which is a subset
of the data in col A). Your formula only compares A and C cells in the same
row. Anyway, I've now found the solution:
In column D (D2:D538) I copied
=VLOOKUP(A2:A$538,rangename,1,FALSE)
which placed the col A value where it matched exactly and #N/A everywhere
else.

"reneets" wrote:

Assuming your first data line starts in cell A1, in column D1 use the formula
=exact(A1,C1). This will return a true or false value.

"simon howard" wrote:

I want to find all cells in column A that do not have an identical matching
cell in column C. Ideally I'd then like to list these in column D. Columns A
and C only contain text.

Search range for text not in another range
 

Oops..it's slightly simpler:
=VLOOKUP(A2:A2,rangename,1,FALSE)

"simon howard" wrote:

Thanks Reneets for your quick reply - I should have made it clear that the
matching cell in column C could be anywhere in that column (which is a subset
of the data in col A). Your formula only compares A and C cells in the same
row. Anyway, I've now found the solution:
In column D (D2:D538) I copied
=VLOOKUP(A2:A$538,rangename,1,FALSE)
which placed the col A value where it matched exactly and #N/A everywhere
else.

"reneets" wrote:

Assuming your first data line starts in cell A1, in column D1 use the formula
=exact(A1,C1). This will return a true or false value.

"simon howard" wrote:

I want to find all cells in column A that do not have an identical matching
cell in column C. Ideally I'd then like to list these in column D. Columns A
and C only contain text.