counting duplicates and uniques comparing two columns

  • Thread starter Thread starter Johndb
  • Start date Start date
J

Johndb

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
 
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
 
This worked great, thanks.

T. Valko said:
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
Click to expand...
 
Back
Top