ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   =Sumproduct Question (https://www.excelbanter.com/excel-programming/445284-%3Dsumproduct-question.html)

JAgger1

=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?


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com