View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAgger1 JAgger1 is offline
external usenet poster
 
Posts: 42
Default =Sumproduct Question

I have two sets of numbers in cells A1:J1 and A2:J2

I'm using =sumproduct(--(countif(A1:J1,A2:J2)0)) to get a count of
how many numbers in the two sets match. If I have 5 matching numbers
from these two sets, how would I expand this formula to copy the
matching numbers into cell K2:O2?