How to Count Dates in 2 Lists
 

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!

How to Count Dates in 2 Lists
 

=COUNTIF(C2:C10,A2)


On Jan 10, 10:09*pm, foofoo wrote:
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!

How to Count Dates in 2 Lists
 

On 10 jan, 18:09, foofoo wrote:
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!

How to Count Dates in 2 Lists
 

Or, if you want to copy it down, =COUNTIF(C$2:C$10,A2)
--
David Biddulph

muddan madhu wrote:
=COUNTIF(C2:C10,A2)


On Jan 10, 10:09 pm, foofoo wrote:
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!