, 14 2016 . 20:43
+
9 Excel
Excel . 5% , . Excel-, -, . (', 15.)
1.
, Excel , . ( 1), . , :
ALT F11.
.
, .
Visible xlSheetVeryHidden. , , .
2.
-. , . , ?
.
. .
.
=2=().
.
ʻ. , , .
-. .
3.
- , . . 10 , , , .
1:10, .
.
.
=ר($A$1:$A$10;A1)<=1.
, .
ʻ.
4.
, , . , ANTON (Boston Crab Meat).
G4 ANTON.
G5 Boston Crab Meat.
G7, , {=((3:21=G4)*( B3:B21=G5)*D3:D21)}. , , .
{= , .
(3:21=G4) ANTON.
(B3:B21=G5) Boston Crab Meat.
D3:D21 , .
Enter Excel Ctrl Shift Enter.
5.
, , , , . , . , , . Excel . , :
.
ʻ.
, , .
6.
, : , , . , .
C7.
=(.
B2:B5.
, Excel .
C2:C5 ( 2).
Enter Excel Ctrl Shift Enter.
7.
Excel. , , . 1- 2- 4 11 2010 . , .
, .
, , .
.
: ) ; ) , , D4; ) .
ʻ , D4, .
.
4 11 .
=D5-C5, .
4 11 . : =( _; ; _; _).
_ , . .
, . , 4- .
_ , . . .
_. , , , , .
, . ( , F4).
, , . , , , .
:
9 Excel
2
: 1