| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Match Formula?
On Jun 17, 4:09*am, Martin Brown
wrote: On 16/06/2011 23:35, joeu2004 wrote: On Jun 16, 7:46 am, *wrote: Sorry, my bad. I should have said how many numbers from set B occur in Set A, not which numbers match in value and postion. I'm sorry, but that is exactly what you said the first time -- well, the second time ;-). On Jun 16, 5:18 am, *wrote: Sorry, I should have said, how would I write a formula that would tell me how many numbers from set B match numbers from set A. =SUMPRODUCT(--(COUNTIF(A1:A1000,B1:B30)0)) ITYM =SUM(COUNTIF(A1:Z1,A3:Z3)) Entered as an array formula Ctrl-Shift-Enter Regards, Martin Brown Perfect! Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| Formula to Increment a number upon a match in an adjacent cell | Excel Worksheet Functions | |||
| How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
| Compare/match positve number against negative number? | Excel Programming | |||
| Compare/match positve number against negative number? | Excel Programming | |||
Threaded Mode
