counting duplicates and uniques comparing two columns

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
 
T

T. Valko

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
 
J

Johndb

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
comparing columns in two spreadsheets 1
Counting unique entries across two or three columns 17
Conditional count 2
Comparing data from two columns 2
Compare two datasets and extract unique records from each 3
Count Unique Combinations 6
countif comparing two columns 4

Top