How to Count Dates in 2 Lists

F

foofoo

Hello -

I have 2 columns and each contains a list of dates. Is there a
formula I can use to show how many times each date in column A appears
in the list in column C? I would like to see the results in Column B,
and an example of what I am looking for is shown below.

Column A Column B Column C
12/21/08 3 01/01/07
0/01/08 0 12/21/08
01/02/09 1 12/21/08
01/03/09 0 01/02/09
01/01/07 1 12/21/08


Thank you!
 
J

JB

Hello -
=COUNTIF($C$1:$C$100,A1)

JB
http://boisgontierjacques.free.fr/

I have 2 columns and each contains a list of dates.  Is there a
formula I can use to show how many times each date in column A appears
in the list in column C?  I would like to see the results in Column B,
and an example of what I am looking for is shown below.

Column A     Column B     Column C
12/21/08           3              01/01/07
0/01/08             0              12/21/08
01/02/09           1              12/21/08
01/03/09           0              01/02/09
01/01/07           1              12/21/08

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top