Calc Guide

The first argument is the cell area with the times of all approximately
38,000 emails. The second argument is the cell area E2:E25 that
describes the frequency classes. To enter the formula, first select the
cell area F2:F25, then enter the formula. Then finish the formula by
using the key combination Shift+Ctrl+Enter. This indicates to the
program that you want to use a matrix formula. To indicate the matrix
formula, the program uses curly brackets.
This technique is most often known only to advanced users.
Solution with the DataPilot
With the DataPilot you can achieve the same result much easier and
faster. The solution is also possible for less advanced users. Starting
with the raw data (Figure 173), you need only a few mouse clicks.
1) Select the cell A1 (or any other cell within the list).
2) Choose Data > DataPilot > Start and click OK.
Figure 175: Part of DataPilot dialog
Chapter 8 Using the DataPilot 237