how do I select unique dates from a database in Excel?

[Guest]

The spreadsheet contains dates which are associated with respective
incidents. I need to count daily the number of incidents for a specific
date. The daily numbers are rolled into a weekly report. I have been able
to slect unique dates by using Conditional Sum, but I would like to automate
the query. Conditional Sum only works for dates that exist in the
spreadsheet. Additionally, it seems I must create the Conditional Sum
function for each date and also cannot copy the function. Any help is
appreciated.

 

[JulieD]

Hi

use the COUNTIF function
with the date you're interested in in cell M2
and the range of dates in column G
use the following formula

=COUNTIF(G:G,M2)

Cheers
JulieD

 

[Guest]

This worked great. If we could take it a step further. Each date is
associated with an incident which is rated by impact level and also the
duration of the incident. I also would like to sum the minutes of the
duration for the impact level for the specific date. Date looks like this:

Date Impact Minutes
1/4/05 Medium 40
1/5/05 High 60
1/28/05 Medium 20
1/28/05 Medium 10

I'm trying to say there is 1 medium impact on 1/4 for 40 minutes; 1 high on
1/5 for 60 minutes, 2 medium on 1/28 for a sum of 30 minutes. I plot these
numbers on a graph but am using verbiage here to describe the case. If you
need more info, please advise. Your help is greatly appreciated.

 

[JulieD]

Hi

i would use a pivot table for this, click inside your data and choose data /
pivot table and pivot chart report
then next
then check the range and next
then in a new worksheet and finish

now drag the "date" to where the word row appears, drag the "impact" to
where the word column appears and drag the "minutes" to where the word data
appears - this should give you what you want. then you can click on the
graph icon on the pivot table toolbar to turn it into a graph.

Cheers
JulieD