counting duplicates and uniques comparing two columns
 

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

counting duplicates and uniques comparing two columns
 

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

counting duplicates and uniques comparing two columns
 

This worked great, thanks.

"T. Valko" wrote:

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

counting duplicates and uniques comparing two columns
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Johndb" wrote in message
...
This worked great, thanks.

"T. Valko" wrote:

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