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.