, .
: -> -> (DATA-Form-Criteria). . -:
? ,
* - ,
< > <= >= = .
, .
(.1) .4 1- (.3).
.4
: -> (DATA-Sort)
. -> (DATA-Sort) .5.
.5
, . (Sort by), (Then by), (Then by) . : (Ascending) , , (Descending) . . , .
, .1, (.6).
.6
, , . .7.
.7
, , , : ->-> (Data-Filter-AutoFilter) ->-> (Data-Filter-Advanced Filter)
. ->-> (Data-Filter-AutoFilter) (.8). (). .
.8
, (Custom Filter). , . .9 80 240 .
|
|
.9
.10.
.10
, , . , (Data-Filter-AutoFilter) ( ->->).
(->-> ) (Data-Filter-Advanced Filter) .
.
(.1) , :
1. 04.01.2000-30.05.2000 " " 50 ,
2. () 02.02.2000-14.02.2000 "", 400 ,
3. () , 01.05.2000-30.05.2000,
4. () " ".
:
. 2, .11.
.11
, . , . , , . , , .
. . 2.
, ( . 1), , ( \, , , , ... , , , , (.), (), , /). , (. 12).
.12
(->-> ) (Data-Filter-Advanced Filter) (. 13).
.13
. , . ( , .. .1). . . .11 ( ) .1 ( ).
OK , .14.
.14
. . , . , , , . . , , =I3*J3; =I4*J4 .. , , . . . .15, , .1.
|
|
.15
. . ( -> ) (Data-Sort). .16.
.16
( ->) (Data-Subtotals). (.17). . : (At each change in) , . (Use function) . , . : , . (.17). OK , .18.
.17
.18
.18
. (. 18, 18) , , (.19).
.19
(.19) , ( - ), .
:
1. ?
2. ?
3. ?
4. ?
5. ?
6. ?
7. ?
8. , ?
9. ?
10. ?
11. ?
12. ?
13. ?
14. ?
15. ?