Microsoft Office Tutorials and References
In Depth Information
Top Regions
#
Region
These figures use a variation of an earlier
example. Here, the first page of the report
(shown in the top figure) uses all three of the
slots, or sections, available for data. The second
page hides the last slot. Both pages were printed
by the worksheet below.
1New York
Score:
193
2 Calif ornia
Score:
179
3 Kansas
Score:
165
Top Regions
#
Setting Up the Worksheet
The worksheet shows four named cells. Cell E15
contains the formula =MAX(C2:C13). Cell E16
contains the value 3, the number of slots
available in the worksheet.
Region
4 Alabama
Score:
161
5 Montana
Score:
157
6 /A
Score:
#N/A
Cell E17 contains the value 1, which
specifies the first page of the report. To
specify the second page, enter 2 and
recalculate.
AB C
D
E
F
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Top Regions
# i n
e
1 New York
193
2 California
179
3 Kansas
165
4 Alabama
161
5 Montana
157
Cell E18 returns the total number of
pages. Its formula is:
=ROUNDUP(DataRows/Slots,0)
5
#N/A
#N/A
5
#N/A
#N/A
5
#N/A
#N/A
5
#N/A
#N/A
5
#N/A
#N/A
Cells A23, A25, and A27 contain the
values shown. I’ll explain column B
shortly.
DataRows
5
Slots
3
PageCount
1
Pages
2
Each slot of the report contains three
formulas. In the first slot:
Top Regions
#
Region
1
1 New York
Score:
C23: = (PageCount-1)*Slots+A23
D23: = OFFSET(D\$2,\$C23,0)
E24: = OFFSET(E\$2,\$C23,0)
193
2
2
2 California
Score:
179
3
3
3 Kansas
Score:
165
Cell D24 contains the text shown.
Search JabSto ::

Custom Search