Assuming that each column contains only unique entries...

Duplicates:

=SUMPRODUCT(--(ISNUMBER(MATCH(R2:R8,S2:S8,0))))

Uniques:

=COUNTA(R2:S8)-the result of the above formula

--
Biff
Microsoft Excel MVP


"Johndb" wrote in message
...
Could use a hand.

I have two columns of data, such as:

Column R Column S
Smith Eastwood
Jones Wayne
Washington Smith
Jefferson Segal
Grant Vin
Wayne Washington
Lincoln Bush

I need to be able to count the amount of duplicates and the amount of
unique
data.

Thanks in advance,

John