Need help for macro to find and count matches in Excel

[Dorian65]

I need to create a macro to do the follow:
In a Excel table
A B C
------
a
b
c
d
i will paste a data in a column C for instance

A B C
------
a 0 b
b 0 b
c 0 f
d 0

The result I'm looking for is to find number of matches in A and B and if there is not match to add element to column A as follow:
A B C
-----
a 0 b
b 2 b
c 0 f
d 0
f 1

[oeldere]

See the attached file (green cells) for the data that match.

[Dorian65]

See the attached file (green cells) for the data that match.

Thanks!But actually i'm looking for something like this:

Dim wb As Workbook, ws As Worksheet, ws2 As Worksheet
Dim cell As Range

Set wb = ActiveWorkbook
Set ws = Sheets("sheet1") 'Column "A" data


For Each cell In ws.Range("C1", ws.Range("C65535").End(xlUp))
If ws.Range("A:A").Find(cell, , , xlWhole) Is Nothing Then
ws.Range("A65535").End(xlUp).Offset(1, 0) = cell
End If
Next cell

But this macro only adds missing data.