View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adodson adodson is offline
external usenet poster
 
Posts: 13
Default Compare columns, count matches

I'm looking to compare two lists (a1:a10 compared to b1:b10, unnamed). Then,
return the count of original matches between the two lists. For example, if
Joe Schmidt shows once in a1:a10 and twice in b1:b10, then count it only once.

Any advice greatly appreciated? Thank in advance.

P.S. = this will be incorporated into an If statement.