Thread: Comparing and counting occurences in 2 columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Comparing and counting occurences in 2 columns
Hi,

You can use CountIf()

=COUNTIF(Column1,Criteria)

Regards,
Bondi

Reply With QuoteReply With Quote