=Sumproduct Question

J

JAgger1

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Matching Numbers To New Cell's 5
=SUMPRODUCT Question 1
Sumproduct Problem 4
SUMPRODUCT Error 2
RAND() function error? ## 6
Removing Sequential Numbers 5
Create a list using two criteria 4
If function with average fomula to be tru or false 1

Top