| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing and isolating duplicates in two columns | Excel Worksheet Functions | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Comparing and counting occurences in 2 columns | Excel Worksheet Functions | |||
| Comparing two worksheets with two columns each for duplicates | Excel Discussion (Misc queries) | |||
| Comparing Columns and Counting | Excel Discussion (Misc queries) | |||
Hybrid Mode
