View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RodJ RodJ is offline
external usenet poster
 
Posts: 11
Default matching numbers

Would appreciate help with this request:

I have two sets of numbers in rows: eg:

2,10,16,20,38,39,42,45
3,10,15,32,36,38,40,42

I want a function that would tell me how many in the first row match with
the second row? Answer I am looking for is = 3.

Thanks in advance
RodJ


--
RodJ