View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Johndb Johndb is offline
external usenet poster
 
Posts: 16
Default 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