Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping Data
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: http://www.excelforum.com/member.php...o&userid=28583 View this thread: http://www.excelforum.com/showthread...hreadid=525591 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping Data
Column 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 €˛ForgetMeNot€¯ ezt Ć*rta: 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: http://www.excelforum.com/member.php...o&userid=28583 View this thread: http://www.excelforum.com/showthread...hreadid=525591 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
Grouping Data in Excel | Excel Discussion (Misc queries) | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |