Excel
1
1. (10-15 ).
2. , (, ).
3. - - (Insert - Name - Define) ( , !) ( ). .
4. ( ), - (Data - Validation). (.. =).
.
, .
2
, .
(INDIRECT), .
, 1:10 .xls, :
=("[.xls]!$A$1:$A$10")
, . , , .
, , :
=("'C:\TEMP\[.xls]'!$A$1:$A$10")
.
.
3
(INDIRECT), - , Excel. , "1", 1. "", .. , , " ";).
!!! ..
, , Toyota, Ford Nissan:
( 2 ) Toyota - - (Insert - Name - Define). , Ford Nissan.
. ( F3) - (Data - Validation), - ( , .. 1:1). :
|
|
, . , , - - . :
=(F3)
F3 - - .
. , .
.
4
3, .