software

I have a spreadsheet with the following values:

AB
01-JAN-06John Smith
01-JAN-06Jane Doe
01-FEB-06John Smith
09-FEB-06John Smith
etc.

Either in the same or new worksheet, I want to calculate the number of
times quot;John Smithquot; and quot;JANquot; appear in the same row, quot;Jane Doequot; and
quot;JANquot;, quot;John Smithquot; and quot;FEBquot;, etc.

The expected results would appear as follows:

January
John Smith1
Jane Doe1

February
John Smith2
Jane Doe0

What is the formula needed to accomplish this?--
bpliskow
------------------------------------------------------------------------
bpliskow's Profile: www.excelforum.com/member.php...oamp;userid=31645
View this thread: www.excelforum.com/showthread...hreadid=513340=SUMPRODUCT(IF(TEXT(A1:A100,quot;Mmmmquot;)=quot;Januaryquot;,1,0) ,IF(B1:B100=quot;John
Smith,1,0))

HTH
Kostis Vezerides