Search range for text not in another range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel VBA 1
VBA set thick borders around non empty cells in range 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Display text from a single cell in a column range 2
SUMIF with NAME RANGE 1
Check text in range of cells 2

Back
Top