View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Need help similar to a histogram

would this

14:31:09 0
14:31:10 1
14:31:14 1
14:31:15 0


be one flag or two?

--
Regards,
Tom Ogilvy

"DonD" wrote in message
...
Greetings,


I am trying to analyze some data that looks like this:
Time Flag
14:30:02 0
14:30:16 0
14:30:32 0
14:30:32 0
14:30:48 0
14:30:48 0
14:30:56 0
14:30:57 0
14:31:09 0
14:31:10 1
14:31:14 1
14:31:15 0
14:31:20 0
14:31:23 0
14:31:37 0
14:31:41 0
14:31:45 0
14:31:57 0
14:31:57 0
14:31:59 1
14:32:14 0
14:32:16 0
14:32:20 0
14:32:23 0
14:32:27 0
14:32:28 0
and so on....


From this data I want to make a kind of histogram of how many flags

appeared
in a given time range, say every 2 minutes. So for example, a sum of the
flags each 2 minute period.


Thanks and cheers

Don