View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default find dates between in excel

With names in Column A, and dates in Column B, one way would be to enter a
name to count in C1, and the number of the month (Jan=1, Feb=2, ... etc.)
in
C2, and try something like this:


Another possibility which is more "visual" (you will be able to see the
matching rows). Assuming the same set up above, put this formula in D1...

=A1&" - "&MONTH(B1)

and copy down to the end of your data. Then put this formula in E1...

=IF(AND(A1=C$1,MONTH(B1)=C$2),COUNTIF(D$1:D$10000, "="&A1&" - "&C$2),"")

(using a number larger than the number of rows of data you have for the
10000 I used) and copy down to the end of your data (or beyond if your data
can grow). Now, when you put a name in C1 and a month number in C2, each
matching row will be flagged in column 'E' with the total number of hits for
that match.

Rick