Posted to microsoft.public.excel.programming

external usenet poster

Posts: 42

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumproduct question	SteveDB1	Excel Worksheet Functions	1	September 21st 07 11:36 PM
Sumproduct question	Barb Reinhardt	Excel Worksheet Functions	1	September 7th 06 10:38 PM
SUMPRODUCT Question	John Moore	Excel Discussion (Misc queries)	2	October 18th 05 12:31 PM
another sumproduct question	cjjoo	Excel Worksheet Functions	1	October 11th 05 03:43 AM
sumproduct question	Dominique Feteau	Excel Worksheet Functions	8	July 26th 05 08:43 AM

All times are GMT +1. The time now is 02:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us