software

I have the following data:

Code:
--------------------
22/03/2006 0:10
22/03/2006 3:22
22/03/2006 8:59
22/03/2006 11:12
22/03/2006 13:31
22/03/2006 13:56
22/03/2006 14:16
22/03/2006 14:22
22/03/2006 15:38
22/03/2006 15:40
22/03/2006 16:07
22/03/2006 16:58
22/03/2006 17:36

--------------------I would like to know if it is possible to produce a report so that I
can see something lik ethe following:

22/03/2006 16:00 10
22/03/2006 17:00 5
-------------------------------
Column 1: Date
Column 2: Time
Column 3: Number of Entries within the last hour--
ForgetMeNot
------------------------------------------------------------------------
ForgetMeNot's Profile: www.excelforum.com/member.php...oamp;userid=28583
View this thread: www.excelforum.com/showthread...hreadid=525591Column A Column B
22/03/2006 16:00 formula
22/03/2006 17:00

Select B1:B3 cells (one more than No of entries in column A) and type in
this formula: =FREQUENCY(Sheet1!A$1:A$13,A$1:A$2)
Cofirm it with Ctrl Shift Enter because it's an array formula!

Adjust references to your real ranges!

Regards,
Stefi?orgetMeNot??ezt ?rta:

gt;
gt; I have the following data:
gt;
gt; Code:
gt; --------------------
gt; 22/03/2006 0:10
gt; 22/03/2006 3:22
gt; 22/03/2006 8:59
gt; 22/03/2006 11:12
gt; 22/03/2006 13:31
gt; 22/03/2006 13:56
gt; 22/03/2006 14:16
gt; 22/03/2006 14:22
gt; 22/03/2006 15:38
gt; 22/03/2006 15:40
gt; 22/03/2006 16:07
gt; 22/03/2006 16:58
gt; 22/03/2006 17:36
gt;
gt; --------------------
gt;
gt;
gt; I would like to know if it is possible to produce a report so that I
gt; can see something lik ethe following:
gt;
gt; 22/03/2006 16:00 10
gt; 22/03/2006 17:00 5
gt; -------------------------------
gt; Column 1: Date
gt; Column 2: Time
gt; Column 3: Number of Entries within the last hour
gt;
gt;
gt; --
gt; ForgetMeNot
gt; ------------------------------------------------------------------------
gt; ForgetMeNot's Profile: www.excelforum.com/member.php...oamp;userid=28583
gt; View this thread: www.excelforum.com/showthread...hreadid=525591
gt;
gt;