Grouping data

[Marielle_van_Gils]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I want to group data:
all transactions that took place in time intervals (per hour)

How can I display the total number of all transactions per time interval?

Thank you for your response!

 

[CyberTaz]

It depends on the nature of the data & how you have it arranged. The first 2
options that come to mind is the Subtotals feature found in the Data menu as
well as the use of a Pivot Table.

See the following topics in Excel Help:

Add up totals for sales data
Analyze your data with PivotTable reports

HTH |:>)
Bob Jones
[MVP] Office:Mac