Match between two lists

**Chance2** · 05-05-2009, 08:08 PM

How about a CSE formula...

=SUM(COUNTIF($A$1:$A200,$B$1:$B$15))

Enter this formula into C1 and then use Ctrl+Shift+Enter to get the brackets.

**penumbra547** · 05-05-2009, 08:24 PM

Originally Posted by Chance2

How about a CSE formula...

=SUM(COUNTIF($A$1:$A200,$B$1:$B$15))

Enter this formula into C1 and then use Ctrl+Shift+Enter to get the brackets.

This worked too!! I need to really dig into the CSE formula. I've heard of this in passing many times, and don't it well enough to know how to apply it.

Thanks!

**shg** · 05-05-2009, 11:43 PM

Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes