| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many times a date appears
I have an excel worksheet with inspection dates in column c and reinspection
dates in column d. In columnn e I have the dates of the year. I want to determine how many times each date appears in comumn c and d. my final result will be a simple chart from this data. Thanks in advance, Fyrefox |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count how many times a date appears
For inspection dates, next to E1:
=COUNTIF(C:C,E1) For total occurrences (inspection and reinspection): =COUNTIF(C:D,E1) HTH Kostis Vezerides On Oct 12, 5:11 pm, fyrefox wrote: I have an excel worksheet with inspection dates in column c and reinspection dates in column d. In columnn e I have the dates of the year. I want to determine how many times each date appears in comumn c and d. my final result will be a simple chart from this data. Thanks in advance, Fyrefox |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I WANT TO COUNT HOW MANY TIMES A CERTAIN LETTER APPEARS IN A ROW | Excel Worksheet Functions | |||
| How do I count the number of times a value appears? | Excel Worksheet Functions | |||
| display and count the number of times a value appears | Excel Worksheet Functions | |||
| Count Number of Times Something appears | Excel Worksheet Functions | |||
| How do I count how many times x appears in a column? | Excel Worksheet Functions | |||
Linear Mode
