| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare lists - count # records | Excel Worksheet Functions | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| Lists with dates in them | Excel Discussion (Misc queries) | |||
| How to use different =COUNT with Lists | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Linear Mode
