![]() |
=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