I have one column with names, the other with dates. Each name has multiple
rows of different dates.
I'd like to count the number of times each individual name has a date
occurrence before a specific date.
e,g.,
A B
Smith 7/31/2009
8/3/2009
7/24/2009
7/25/2009
8/4/2009

Jones 7/26/2009
8/5/2009
8/8/2009
7/31/2009

Specific date is 7/31/2009, so Smith would have 2, and Jones would have 1.

Thanks a million.